Conditional Formatting

[Solved/Closed]
Report
Posts
3
Registration date
Friday January 25, 2013
Status
Member
Last seen
February 1, 2013
-
Posts
3
Registration date
Friday January 25, 2013
Status
Member
Last seen
February 1, 2013
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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)
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
RayH,, "" is also <=13. So I am guessing you would need to test of <>"" condition too .
Posts
3
Registration date
Friday January 25, 2013
Status
Member
Last seen
February 1, 2013

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.