Automatic colouring of cells
 

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

Automatic colouring of cells
 

Look at format_conditionalformating

cell value <0 choose yellow as the pattern

cellvalue 25 choose red as the pattern

Regards

Dav


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

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