## Forum Discussion

EMonroe1963

Jan 30, 2024Copper Contributor

# 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.

EMonroe1963

Copper Contributor

That worked as well. Thank you! Here is the toughest portion I face. I've tried to send this to you earlier and hoping it works now. I need a formula to help determine correct capitalization for these fields: E, F, G, and H (Canadian Postal Codes) that will read out TRUE or FALSE in Field J. I have a formula that works for fields E and F but I am unable to develop one that will cover all four fields. I'm attaching this small excel sheet. Hopefully you will be able to see it this time.

HansVogelaar

Feb 01, 2024MVP

A full solution would be complicated, since you'd have to handle names such as McCartney and DeLorean.

A partial solution:

=AND(EXACT(PROPER(E2:H2), E2:H2))

If you do not have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.