Ask Your Question

Revision history [back]

Conditional Cell Coloring

So I have a question,

I have a project going on with a lot of cell numbering involved.

If a cell has a certain value that a different cell will receive a color background, I want to know if this is possible. To give a specific example - I have a word counter in that document that registers words like 'collecting' -

Collecting would be in cell D3 - and the amount of times the word occurs in that specific tab is in E3 through the following formula =COUNTIFS(B2:B1000; "Collecting") - And when the number in E3 exceeds let's say for example '3' then I want F3 to have the background color red.

If anything is unclear let me know, english is not my mother language.

Best Regards, James