View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul B. Paul B. is offline
external usenet poster
 
Posts: 10
Default Conditional Format??

I have set my conditional format so that is a column A2 is Pass then B2 turns
green, and if A2 is Fail then B2 turns red.

I also want B2 to not change colour if A2 is NOT Pass or Fail.

Any ideas would be appreciated.

Cheers