P
Patrick C. Simonds
I have a worksheet with 941 rows. I need a macro that will look at each row
and if the value in of the cell in column Z of that row = 2 it should format
the cell in column C Yellow, if the cell in column Z of that row = 3 it
should format the cell to Red, and if the cell in column Z of that row is
grater than 3 it should format the cell to Grey with white text. If the Cell
in column Z is equal to 1 or less the cell in column C should be the normal
format which has been set for it.
I know this can be done easily with conditional formatting in Office 2007,
but I am doing this to be used with Office 2003 and with the other
conditional formats I have in place, I have exceeded the 3 conditional
format limit.
and if the value in of the cell in column Z of that row = 2 it should format
the cell in column C Yellow, if the cell in column Z of that row = 3 it
should format the cell to Red, and if the cell in column Z of that row is
grater than 3 it should format the cell to Grey with white text. If the Cell
in column Z is equal to 1 or less the cell in column C should be the normal
format which has been set for it.
I know this can be done easily with conditional formatting in Office 2007,
but I am doing this to be used with Office 2003 and with the other
conditional formats I have in place, I have exceeded the 3 conditional
format limit.