Previous Topic Next Topic

Conditional formatting

Closed
lynneb1984 - Oct 19, 2009 at 05:42 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 21, 2009 at 06:53 AM
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 response

Answer 1 / 1
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Oct 21, 2009 at 06:53 AM
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
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses