Hi,
I'm trying to colour code data contained in a report but struggling to achieve it.
The code below works ok but contains a colour coding section at the bottom which produces an error message 13 - type mismatch
I want to colour cells F,G & L for each row based on the value of AR on that row - less than 0 is red, 0-7 is yellow and 8> is green.
Would anyone be able to help please?
Thanks,
Please Login or Register to view this content.
Louise
Last edited by Brontosaurus; 11-28-2010 at 10:45 AM.
Tryremoving the quotes and so on for the similar codes. Also, why don't you use conditional formating for coloring?Please Login or Register to view this content.
rgds
johnjohns
Hi,
I still get the error message
I'm not using conditional formatting as the source data is located elsewhere and copied into this worksheet to create a regular report based on topical source data.
Therefore all of the processing/formatting is done in this macro.
Thanks,
Louise
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks