Welcome!

Conditional Formatting - conditions in one row apply to another

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

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!

SmartSheets Changing Date Format (UK to US) in some emails?
We are UK based and use the Day/Month Date Format (i.e 09/02/2026 - 9th of Feb 2026) In some, but not all, of the "Send.." rows email, the date format changes to the American version (02/09/2026). Is there any way to stop this happening?
Automation Not Working?
Hello, I have an approval path for update requests. It starts with a form, and it currently isn't being received after being handed off by the PCM. So, starting on page 3, the Area Director isn't receiving the update request. I have myself filled in for most of the steps which will be changed once I get this sorted, but…
Data deleted in error earlier today, can I get it back? (Undo button not active)
Earlier today it looks like several columns of data had the "clear contents" action taken in error. Is there a way to get that back other than using the snapshot feature and manually adding it back to a sheet with conditional formatting etc.? thanks in advance for taking a look1