ariannannanna
New Member
- Joined
- Mar 5, 2014
- Messages
- 1
Hi there,
I'm trying to color a row of data based on the data in multiple cells.
To be specific, I want to color Row 2 red when J2 is blank AND when any of A2-I2 are not blank ( (so either A2, B2, C2, D2, E2, F2, G2, H2, or I2 are not blank) . Then I want to apply this to the whole document. Please help!
Thanks!
I'm trying to color a row of data based on the data in multiple cells.
To be specific, I want to color Row 2 red when J2 is blank AND when any of A2-I2 are not blank ( (so either A2, B2, C2, D2, E2, F2, G2, H2, or I2 are not blank) . Then I want to apply this to the whole document. Please help!
Thanks!
