excel 2003 conditional format

Topic

New Reply

[hi all,
the attached file has data sample that i want to format using conditional format. ihave three condition,less than 100(red),greater than 100(green),blank(yellow).

TIA
dubdub

Reply | Quote

Replies

[hi all,
the attached file has data sample that i want to format using conditional format. ihave three condition,less than 100(red),greater than 100(green),blank(yellow).

TIA
dubdub

Not sure what you want for cell = 100, but this does what you want (works in Excel 2007 – should be similar in 2003)

Reply | Quote

thanks Gfamily for the help.

dubdub

Reply | Quote