Hi,

Conditional Formatting only allows 3 conditions, but I need 5,
so that in F Column, if I insert:

Won (cell turns green)
Proposed (cell turns amber)
Lost (cell turns red)

etc.etc.

I think this involves Worksheet_Change
and Target

Any help appreciated
Thanks