Hi,
go to cell AA2, then press Shift+End+ down arrow, then use conditional
formating, Highlight cell where text contains Reject, choose your color, do
the same with Accept and consider. Go to column AB and do the same

if this helps please click yes thanks

"Kim" wrote:

I need to do a macro with the following condition:

Cell Value contains 'Reject' - Red
Cell Value contains 'Accept' - Green
Cell Value contains 'Consider' - Orange

I need the conditional format on column AA & AB. (But need to exclude Row 1).

Thanks