View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norie Norie is offline
external usenet poster
 
Posts: 1
Default Change cell format based on condition.


How will the individual cell get the red fill?

If it's through conditional formatting you could extend the conditiona
formatting over the range.

If it's any other way I think you would require VBA code

--
Nori
-----------------------------------------------------------------------
Norie's Profile: http://www.excelforum.com/member.php...fo&userid=1936
View this thread: http://www.excelforum.com/showthread.php?threadid=38410