Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
conditional formatting

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional formatting

Conditional formatting

ResolvedVersion 2007

Jess has attended:
Excel Intermediate course
Excel Advanced course

Conditional formatting

Hi there

What i would like to do is the following:

A column has a Yes/No reply required. If a 'No' response is given, I would like to change the whole row to be greyed out as irrelevant.

Is this possible, and if so, how, please?

Thank you

RE: Conditional formatting

Hi Jess,

Thank you for your question and welcome to the forum.

Select all the data first and then go to Conditional Formatting. Create a new rule and choose 'Use a formula...' option. Type something similar to the following:

=$g6="yes"

You fix the column by using an absolute cell reference on the appropriate column that will contain the yes values.

I hope this answers your question. If it does can you please mark the question as resolved.

Regards

Simon

Please browse our web site to find out more about
excel classes and other training courses.

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.1 secs.