I would like a cell from a range to change colour whenever some text is
entered into it.
For example, if I type in a date or text like 'yes or no' into a cell
ranging from F4:F44 then it will turn the cell colour yellow.

Could anyone offer any help on this.

Thanks


--
andy617
------------------------------------------------------------------------
andy617's Profile: http://www.excelforum.com/member.php...o&userid=21835
View this thread: http://www.excelforum.com/showthread...hreadid=500150