Conditional formatting a row in Excel

  ShorN 10:10 31 Jul 2006


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 2006

try the 'if' function?


  VoG II 18:15 02 Aug 2006

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.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

5 best 3D model websites

iPhone 8 vs iPhone X

WhatsApp : comment lire vos messages sans que l’expéditeur le sache