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