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