Hi Alex

Try using conditioal formating to achieve your goal I think this will be
easier than using VBA.
--
Tony Green


"Alex" wrote:

Hi, I'm pretty new with VBA. I'm trying to highlight a range of cells for
example (A10:N500) based on cells located in column M. If M10=CA Then
A10:N10 will be highlighted yellow Else If M11=GI Then A11:N11 will be
highlighted orange and about three more coniditons. I would appreciate a
code for this.

-Thank you