Conditional Formatting

M

mattguerilla

Hi,

I want to be able to specify the colour of a cell depending on the
information in a different cell. Ie if the result is 7 or above the other
cell will be yellow, but if the result is above 14 the cell will become red.

any ideas?

Matt
 
B

bpeltzer

In the cell you want conditionally formatted, Format > Conditional
Formatting. Set the condition to read 'Formula is' =$A$1>7 and set the
condition you want. (Substitute your 'different cell' where I put A1).
 
M

mattguerilla

I have done this already but the problem comes when the result is higher than
14. It should go red but it stays yellow. ???


Matt
 
B

bpeltzer

The format gets set by the first condition satisfied. So in your case, make
the test for >=14 (the more restrictive test) the first condition and the
test for >=7 the second.
 
Top