View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Timmy Timmy is offline
external usenet poster
 
Posts: 7
Default Compare two Cells and highlight third cell

I have a worksheet with cell A1 with a certain number and cell A2 with
another number in it. I would like to compare cells A1 vs A2.

If the value is less than A2, then the cell A3 should be highlighted in yellow
If the value is equal to A2, then highlight the cell A3 in green
If the value is higher than A2, highlight the cell A3 in red

Thanks in advance.