View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Steve Steiner Steve Steiner is offline
external usenet poster
 
Posts: 2
Default colouring a cell



"andy617" wrote:


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