Color Row Where Cells In Column Contains Specific Word

clh · May 25th 2008

I have a spreadsheet with 12 coloums. In the last coloum are the words "yes", "no", or is empty (null?). I need to find a way to have each row that contains the word "no" or is empty to be highlighted in red font and bold type. When the word "yes" is typed then the font is black and the type in normal.

This allows me to see at a glance what orders have not been picked up or have problems.

VBA Noob · May 25th 2008

Re: Conditional Formatting Rows

Select Columns A to L then format > conditional formatting.

Then enter

=OR($L1="",$L1="No")

and set formatting as required

VBA Noob

Dave Hawley · May 25th 2008

If you wish to continue using this free service.

Please be considerate of others who use the forum for searching. Your current Thread Title (which I will change) is non-reflective of your immediate problem.

In future, please take 1 minute of your time to read the text on the New Thread page.

[fa]*[/fa]

REMEMBER: Your thread title should NEVER be what you THINK is your answer. 9 times out 10 it will wrong and prevent someone from finding a solution to a simliar issue.

Color Row Where Cells In Column Contains Specific Word

Participate now!

Share