Single Cell Conditional Formatting?

leapm

Is there a way to use conditional formatting on one cell or select cells within a row. I do not want to format the entire column or row since other values that should not be formatting will meet the same condition.

I can't find anything on this.

Thank you!

Andrée Starå

Hi @leapm

I hope you're well and safe!

You can select if it should be on the entire row or select the columns you'd like to include.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

leapm

When I change the place to apply the format from the "entire row" to the column name, it formats the entire column. I only want a few specific cells from the row. I'm not sure how to get around this. Any thoughts?

Andrée Starå

@leapm

You need add a condition for something on that row or rows where you want it to apply.

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

leapm

it doesn't because I either get the entire row or entire column formatted depending on how it's set up. I don't see how to make it specific to just one cell. thank you for your help!

Andrée Starå

@leapm

Do you have any specific that stands out on the row(s) you want to be included in the Conditional Formatting rule?