Thread: Colour macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Little pete Little pete is offline
external usenet poster
 
Posts: 26
Default Colour macro

Afternoon

I have my data that I want to review in column H and depending on the data
in that coloumn colour the entire row (columns A to J).

An example of a code is;
ZL049 which I want to be Yellow
EZ006 which I want to be Green
EY001 which I want to be purple

How do I write and where?

Many thanks
Pete