nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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

Find more posts tagged with

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Form from different sheets
Can I create a form with information from different sheets?
If someone has multiple rows where their contact appears, can they just receive one email?
Hello, I'm trying to not spam the people I need info from. I have 600 courses and need the course owners to fill in some info for me. Some people are the contact for 30 courses. If I just send an automated request for an update, they'll get 30 emails. Can I automate an email so that each contact just gets one request if…
Users unable to update CheckBox
I use Smartsheet for our audit process. It has worked wonderfully all year but a new set of audits just came in and for whatever reason my team has lost the ability to check the completed check box in the sheet. I have checked to make sure the column is not locked, upgraded their permissions to admin. No luck. Screenshot…