ThatOneDude
New Member
- Joined
- Aug 11, 2022
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
I have conditional formatting set up that essentially says "if the status is Active, make the text in that row orange." and another rule that says "if the status is Discontinued, make the text in that row red."
In the example below, the external model represents multiple internal models so I need all the rows underneath to have the same formatting. Basically, I need a conditional formatting rule that says "if the status column is empty, match the formatting of the last row above it where the status column isn't empty." I need the black rows under the orange row to be orange and I need the black rows under the red row to be red, etc.
Is this possible?
In the example below, the external model represents multiple internal models so I need all the rows underneath to have the same formatting. Basically, I need a conditional formatting rule that says "if the status column is empty, match the formatting of the last row above it where the status column isn't empty." I need the black rows under the orange row to be orange and I need the black rows under the red row to be red, etc.
Is this possible?