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
Feb 01, 2024Copper 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.