Hi Chris,


It's not clear which is your input column (cells) and which column do you
intend to color.
I suppose that you input data in A1 and want to color the same cell:

select A1
invoke Conditional formatting
1st condition: formula: =A2=20 choose green
2nd condition: cell value: less then 7 choose red
3rd condition: cell value: equals 7 choose amber

Regards,
Stefi

€žChrisMattock€� ezt Ã*rta:


I have a spreadsheet and need to peform checks to makes sure all of the
data is enetered correctly then I want the output to be a cell which
dislpays red, amber or green depending on the status.

These are the conditions I need,

If Cell A1 < 7 then it should be red. If A1 = 7 then is should be
amber. But if A2 = 20, then it should be grren, no matter what A1 is.

Any ideas?


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=556373