View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Conditional Fomarting

Does this work

Select the cell and conditional formatting

if formula is =AND(B20,C2="") Set to red
2nd condition press ADD
If formula is =AND(B20,C2="Yes") set to green

"Renee" wrote:

I am wanting to put a conditional formating on cell A2 to highlight it red if
cell B20 and cell C2 is blank, but highlight it green if B20 and C2=YES.
I hope this makes sense. Thanks for your help in advance.