Conditional Formatting - conditions in one row apply to another
Betsy Green
✭✭✭
Hi, everyone.
I'd like to apply conditional formating with these parameters...
If row 3 is 100% complete, turn row 4 green.
Can this be done?
Thanks,
Betsy
Comments
-
You could add a helper column that checks if the row above is 100% complete. For example in row 4 you could add:
=IF([% Complete]3 = 1, 1)
Then you can add a conditional format to turn the row green if the helper column equals 1.
-
I second Brian's suggestion. That's the only way I could think to do it.
-
I came up with a similar solution. I added a column that is just an = for my % complete on the prior row, then formatted it accordingly.
Thank you both for the response!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives