How would I change the colour of a cell depending on the result of a formula? I cannot change the formula itself to include an IF function.
I have several cells that im using CONCATENATE on to combine them. The cells im combining do not always have data. If the CONCATENATE only returns 1 character i would like to turn it green. Conditional Formatting is not recognizing it thus far.
if A1 = 1 then green
if A1 = 2 then green
if A1 = 12345 then nothing
Bookmarks