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 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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))
0
=AND(OR(A2="BLUE",A2="RED",A2="GREEN"),A7<=13)
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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.
0