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

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

"mattguerilla" wrote:


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

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

"bpeltzer" wrote:

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

"mattguerilla" wrote:


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

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.

"mattguerilla" wrote:

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

"bpeltzer" wrote:

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

"mattguerilla" wrote:


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