Conditional formatting

Resolved · Medium Priority · Version 2007

Wed 17 Nov 2010, 13:26 Delegate Jess said...

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

Thu 18 Nov 2010, 10:23 Trainer Simon said...

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

Excel tip:

How to Spell Check an Excel 2010 Worksheet

Excel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet.

Either select the ''Review'' tab in the Ribbon, go to the ''Proofing'' section and click ''Spelling.'' Or, simply press F7.

View all Excel hints and tips

Conditional formatting

Conditional formatting

RE: Conditional formatting

Excel articles

Excel tip:

How to Spell Check an Excel 2010 Worksheet