View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Norman Jones
 
Posts: n/a
Default Automatic colouring of cells

Hi Hustler,

See Debara Dalgleish at:

http://www.contextures.com/xlCondFormat01.html


---
Regards,
Norman


"Hustler24" wrote
in message ...

Is there any way that Excel will automatically colour cells that are
above or below certain values.

For example, in a sheet I'm doing, I'd like all negative values in 2
different coloumns to be coloured yellow and all values above 25 to be
coloured red.

Is this possible?

Thanks.


--
Hustler24
------------------------------------------------------------------------
Hustler24's Profile:
http://www.excelforum.com/member.php...o&userid=19678
View this thread: http://www.excelforum.com/showthread...hreadid=556356