I have a series of cells (d3 through ba3) that contain IF formulas. Only two of the cells should actually hit on criteria and display values. One will be "IN" and one will be "OUT". I am wanting to create a conditional format that will cause those cells with "in" or "out" to highlight in yellow, as well as all of those empty cells between the two. Is this possible?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional format cells based on location
- Thread starter knpaddac
- Start date
63falcondude
Well-known Member
- Joined
- Jan 15, 2016
- Messages
- 3,572
Try highlighting D3:BA3, Conditional Formatting, New Rule, Use a Formula,
=OR(D3="OUT",AND(COUNTIF($D3:D3,"IN")=1,COUNTIF($D3:D3,"OUT")=0))
Format with yellow fill. This should work if IN comes before OUT.
=OR(D3="OUT",AND(COUNTIF($D3:D3,"IN")=1,COUNTIF($D3:D3,"OUT")=0))
Format with yellow fill. This should work if IN comes before OUT.
Last edited:
Upvote
0
