Conditional formatting in Excel 2010

[Ian Denton]

I'm trying to format a single cell using conditional formatting to change the colour of the cell based on the following criteria, >=0 = Green, within 10% of the cell next to it Amber and if variance greater than 10% then Red. I'm sure I'm going about it the right way. Please help and please spell it out for me as I don't have much experience in this. Thanks

[dilipandey]

Hi Ian,

Welcome to the forum.

Open the conditional formatting and have below three approaches there :-

>=0
====================
Formula =a1>=0%
and format the cell pattern as green


within 10% of the next cell
====================
=And(a1>0%,a1<=b1*10%)
and format the cell pattern as Amber


greater than 10%
=====================
=a1>b1*10%
and format the cell pattern as Red

where A1 is the cell on which CF logics are getting applied and B1 is the other cell

Above are just the idea to help you proceed further as I guess they won't work if you use them directly in Excel.
Any issues, post the sample file. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[darknation144]

This is very similar to: http://www.excelforum.com/excel-gene...ormatting.html

[BarryTSL]

Fill the cell "Red" and use this as a default so now you only need 2 rules for the conditional formating.
Using the formula option in the conditional formatting use

Please Login or Register  to view this content.

to turn Green
Then on the next rule use

Please Login or Register  to view this content.

to turn Yellow.