Changing the colour of a cell?

[WayneSteenkamp]

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?

[pbaldy]

Presuming you're using a form or report, check out Conditional Formatting on the ribbon.

[WayneSteenkamp]

yeah been playing with the conditional Formatting option. but not having much luck :/
;/

[pbaldy]

Hard to help when I don't know what you've tried.

Can you post the db here?