Ask Your Question

Conditional Cell Coloring

asked 2018-12-13 10:52:29 +0100

ImpulsiveJames gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-12-13 12:17:20 +0100

Hello, @ImpulsiveJames

Click on F3 cell to select it. Then navigate through menu to Format -> Conditional Formatting -> Condition. Under Condition 1 list change Cell value is to Formula isand put formula E3>3. Then select style to be applied if the condition is True. You can choose one of the predefined styles or create your own. Click Ok and when E3 value is more than 3 the selected style will be applied on F3 cell.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-13 10:52:29 +0100

Seen: 74 times

Last updated: Dec 13 '18