If any field is blank, highlight that cell only

tbelly50

I have a formula that returns a "Red" symbol if any of a number of fields is blank, otherwise the symbol is "Green".

=IF(AND([Column1]@row <> "", [Column2]@row <> "", [Column3]@row <> "",[Column4]@row <> "",[Column5]@row <> ""), "Green", "Red")

Is there a way to have any blank fields then highlighted a different color?

Thanks!

Samuel Mueller

The best way to achieve this is probably with conditional formatting. A separate rule on each column looking for blank values.

Conditional Formatting | Smartsheet Learning Center