Is there a macro I can run that will look at column AK and highlight each cell that is >31? I want this macro to work across all of my worksheets
Is there a macro I can run that will look at column AK and highlight each cell that is >31? I want this macro to work across all of my worksheets
Can I ask why use a macro instead of using the Conditional Formatting feature?
![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Since bjcowen wants it only for column AK, i have edited the code given by hafizimran as below -
![]()
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks