Conditional formatting to specific cells only

Kirstine

Is there a way I can apply conditional formatting to only specific calls rather than an entire row or column? In excel I have an area which is red if a job isn't making a profit and green if it is. I want to keep the white bits white though!

Kirstine

I've figured it out! 😁

Andrée Starå

Hi @Kirstine

I hope you're well and safe!

Yes, you can select which columns it should show in the Conditional Formatting rule, but you might need to add so-called helper columns to make it work.

Would 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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Kirstine

Hi @Andrée Starå! I'm good thanks, hope you are too.

I've done something like you're suggesting already but I can still only control 'blocks' rather than cells.

Kirstine

I've figured it out! 😁

Andrée Starå

@Kirstine

I'm excellent!

Glad you got it working! 👍️

Richard Heath

On the flip side of this, is there a way to highlight a number of columns and use the same Conditional Format Rule? I know Excel does this as @Kirstine has shown in her screengrab.

Rather than set up individual rules which essentially repeat themselves for each column, I'd like to have a uniform rule across my sheet to highlight a particular key-word. My sheet for example has 130 columns. I'm not keen on setting up 130 rules.

Andrée Starå

Hi @Richard Heath

I hope you're well and safe!

Unfortunately, it's not possible to look for a key-word, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!