Conditional formatting a row in Excel

  ShorN 10:10 31 Jul 06


I am trying to apply conditional formatting to a spreadsheet so that a row will change its style when either "yes" or "No" is entered into a column. I can make the conditional formatting work when it is equal to a numerical value but cannot seem to work out how to make it apply when "No" is selected.

Any help greatly appreciated!

  johnnyrocker 10:59 31 Jul 06

try the 'if' function?


  VoG II 18:15 02 Aug 06

Choose Formula Is.

In the formula box enter a formula like


Set your formatting. Click in A1 and Copy. Select all of Row 1 and Edit > PasteSpecial, tick Formats.

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Microsoft Surface Studio hands-on review: the iMac killer is here

Best Mac antivirus 2017