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
Harters Posts 3 Registration date Friday January 25, 2013 Status Member Last seen February 1, 2013 - Jan 27, 2013 at 07:36 AM
Related:
- Conditional Formatting
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
- Apply conditional formatting to the selected cells ✓ - Excel Forum
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
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($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
Jan 26, 2013 at 10:46 AM
RayH,, "" is also <=13. So I am guessing you would need to test of <>"" condition too .
Harters
Posts
3
Registration date
Friday January 25, 2013
Status
Member
Last seen
February 1, 2013
Jan 27, 2013 at 07:36 AM
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.