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