Forum Discussion
IF statement to color code a cell
I need a formula to Color Code a cell in an excel sheet. I want the formula to color code to Orange if the wording of the cell is OPEN.
You can do that using conditional formatting, not a formula.
Select the relevant range.
On the home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'equal to' from the second drop down.
In the box next to it, enter the formula="OPEN"
Click Format...
Activate the Fill tab.
Select orange as highlight color.
Click OK, then click OK again.- That worked perfectly for that column. I have another column that I would like to do the same thing for (different color but there is already a formula there: =IF(LEN(E2)>1, IF(LEN(F2)>1, EXACT(PROPER(E2&" "&F2),E2&" "&F2),"FALSE"),"FALSE") so that when I try to do the Conditional Formatting it does not change the color. Do I have to add something to the above formula for it to automatically fill the color when the statement in the cell is "FALSE"?
Replace "FALSE" with FALSE
