Conditional Formatting

Solved/Closed
Harters Posts 3 Registration date Friday January 25, 2013 Status Member Last seen February 1, 2013 - Jan 25, 2013 at 10:21 PM
Harters Posts 3 Registration date Friday January 25, 2013 Status Member Last seen February 1, 2013 - Jan 27, 2013 at 07:36 AM
Hello,

I'm using Excel 2010 and need to conditionally format a cell based on various values in different cells. Specifically, if cell A2 states Blue, Red, or Green and the cell I want to format, A7 is <= 13 then I need cell A7 to format Bold. What is the formula I need to use? Thanks for the help.

3 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jan 26, 2013 at 10:23 AM
formula would be
=AND(OR($A$2="Blue",$A$2="Red",$A$2="Green"),AND(A7<>"",A7<=13))
=AND(OR(A2="BLUE",A2="RED",A2="GREEN"),A7<=13)
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jan 26, 2013 at 10:46 AM
RayH,, "" is also <=13. So I am guessing you would need to test of <>"" condition too .
0
Harters Posts 3 Registration date Friday January 25, 2013 Status Member Last seen February 1, 2013
Jan 27, 2013 at 07:36 AM
Thanks to everyone that helped me solve this. I asked a few different people that I work with but had no luck. Needless to say we all learned something new.