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

Similar discussions

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

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

26 responses
What shall i do after formatting my laptop?
upen91 -
jack4rall -

1 response
Conditional Formatting: 3 range of numbers
LCC -
LCC -

2 responses