Thread: cells automatically colour differently with 'what if' scenarios
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default cells automatically colour differently with 'what if' scenario
Of course it will...

Select A1 & B1

CF1: Formula is =($A1="YES")
Format1: Green

CF2: Formula is =($A1="NO")
Format2: Red

In article ,
ben wrote:

conditional formatting won't help the cell adjacent to it though
Reply With QuoteReply With Quote