select cell (A2?)
and do
format|conditional formatting
Cell value is:
Greater than 200

give it a nice format

Neo1 wrote:

Hello basically I want the cell that has an IF statement to appear
coloured according to the IF statement made for example IF A2100 then
i want cell to appear blue....

How can I do this?

Thanks
From John

--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=516432

--

Dave Peterson