Automatic colouring of cells

[Hustler24]

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.

 

[Dav]

Look at format_conditionalformating

cell value <0 choose yellow as the pattern

cellvalue >25 choose red as the pattern

Regards

Dav

 

[Norman Jones]

Hi Hustler,

See Debara Dalgleish at:

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