Hi,
I have a Lookup field/combo box and want to have the cell colour change if a certain word is chosen. if not then the cells stay the same.
i.e if "cancelled" the cell turns red, if any of the other two options are chosen, then leave as is.
any ideas?