How to automatically change background color of cell based on IF statement
Hi,
assuming you want to color the same cells, where the IF statement is placed, you can do:
- Select the Cells you want to “color” evaluate / color
- Open
Format>Conditional>Condition ... - Add the Conditions ( ie. equals to cell value , etc …)
- Select a preset style to Apply (i.e. Error, Bad, … )
Hope it helps.
How does that change the cell color automatically? What I’m looking for is to put in the cell: if(condition.change color to…). Your solution means I would still have to manually make the change and there is no option for a color change under Format>Conditional>Condition…
If you apply the condition to multiple cells, the color will change according to the conditions supplied.
You can apply multiple conditions to cells. So differnt values result in differnt colored cells.
If that is not what you meant, please update your question and be a little more verbose. Thanks. 