Conditional Formatting .............

[Carl1966]

I have the following totals in cells :

Cell A1 = 100
Cell A2 = 200
Cell A3 = 300

I need to set up 2 conditions for the above data :
1. If the values in each of the cells is the same value what formula do I enter into condition 1 ....... if they are then all 3 cells will show as having a "green" background ?

2. If all 3 cells are different or one of them is different from the other 2, what formula would I use in condition 2 to show the background as "red" ?

With the example values at the start of this message all 3 cells would have a "red" background.

[NBVC]

Select the range and go to Format|Conditional Formatting...

Select Formula Is from 1st drop down and enter formula: =COUNTIF($A$1:$A$3,$A$1)=ROWS($A$1:$A$3)

where A1:A3 is your selected range and A1 is top most cell in the range...

click Format and choose the Green background...

Click add and select Formula Is and enter formula =COUNTIF($A$1:$A$3,$A$1)<>ROWS($A$1:$A$3)

Click Format and choose Red background...

Click Ok.. click Ok again to finish