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