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

Brian W

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.

Paul Newcome

I second Brian's suggestion. That's the only way I could think to do it.

Betsy Green

 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!