View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Scooter Scooter is offline
external usenet poster
 
Posts: 43
Default Conditional Formulas

I have three cells that i would like to be green if they all equal each other
and red if they do not.

Here is an example:
C43 the value is $10.00
C45 the value is $10.00
C49 the value is $10.00

If all three equal each other then I want all three cells to turn green. If
one or more of the values do not match then I want all three to turn red