Conditional formatting help

  • Thread starter Thread starter Kim
  • Start date Start date
K

Kim

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
 
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
 
Hi Eduardo,

I know how to set it on Excel but now I need to create a macro for it.

Regards,
Kim
 
Back
Top