Thanks for taking a look Kevin! I tried the formula in my working version but for some reason the LOOKUP wasn't working. Due to your help though, I reworked the formula to =IF(OR(B3="OFF", C3="OFF", D3="OFF", E3="OFF", F3="OFF", G3="OFF"),"OFF","NOT OFF") and that seemed to fix it. It's not as pretty but this one worked.

The only thing I can think that caused an issue is that the cells containing "OFF" are actually formulas themselves. I forgot to add this into the demo, my bad.

I've reattached the demo with the formula just in case someone else finds a use for it. It also has the formulas that create the "OFF" designator along with formatting. Formatting Demo (OFF).xlsx

Thanks again Kevin!