mike31z
05-22-2012, 11:43 AM
Hi, all. :dunno
What I would like to achieve is to highlight (a light pastel color) a row from column A to P if the value of 2 is in column AC for that row.
I would also highlight (a different light pastel color) a row from column A to P if the value of 4 is in column AC for that row.
I would also need to turn off the highlighting when done. Conditional formating would not work because the full worksheet is sorted multiple ways.
I can then copy the code and change AC to AA for a different sort.
I have attached a sample xls file.
From the attached XL file you can see that column AC is one sort column, Column AA is another sort column. AC and AA are Vlookup columns all the other columns are actual values.
I use excel 2000 but have access to excel2007 if needed.
What I would like to achieve is to highlight (a light pastel color) a row from column A to P if the value of 2 is in column AC for that row.
I would also highlight (a different light pastel color) a row from column A to P if the value of 4 is in column AC for that row.
I would also need to turn off the highlighting when done. Conditional formating would not work because the full worksheet is sorted multiple ways.
I can then copy the code and change AC to AA for a different sort.
I have attached a sample xls file.
From the attached XL file you can see that column AC is one sort column, Column AA is another sort column. AC and AA are Vlookup columns all the other columns are actual values.
I use excel 2000 but have access to excel2007 if needed.