Conditional formatting [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

I am looking to input a formla to shade a cell depending on the result within it. e.g. If the number result is <520 then it should be green, if 520 - 540 then orange and if the number is > 540 it should be red. Please can you advise if this is possible using conditional formatting and how I can achieve this?

Thanks

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hello

This is possible
You have to add three conditions in conditional formatting
the three conditions are
=CELLADDRESS<520
=and(CELLADDRESS>=520, CELLADDRESS<=540)
=CELLADDRESS>540