formula

[Guest]

I have

23 in column 1. (This is the standart) Black color
22 in column 2. want to make diffrent color automatically
25 in column 3. black color


what can i do If I want diffrent color when the nominal less then standar
(22 change to diffrent color automatically)

 

[JulieD]

Hi Kevin

use conditional formatting
click on the 22 in column 2 - assuming cell reference B1
choose format / conditional formatting
from the first drop down box: cell value is
from the second drop down box: less than
in the white line: =$A$1
- adjust the A to reflect the "correct" column reference

click on the format button - choose a colour
click OK twice

Cheers
JulieD