Conditional Formating

Assuming the status column is column 1 and your data starts in column 1, row 2, select cells A2 down to the end of your data/table. Select Conditional Formatting, choose use formula and type in the box:

Formula:

=AND($A2<>"", $A2=0)

for the first condition and format as Green. Repeat for the other conditions with

Formula:

=AND($A2<>"", $A2="!")

and

Formula:

=AND($A2<>"", $A2="X")

Depending on your regional settings, you may have to replace the comma (,) with a semi-colon (


Regards, TMS