I need help creating a macro to highlight entire rows if a cell in that row (C) contains specific values.
Any ideas?
Thanks in advance
I need help creating a macro to highlight entire rows if a cell in that row (C) contains specific values.
Any ideas?
Thanks in advance
Last edited by VBA Noob; 12-24-2008 at 06:21 AM.
You can use a worksheet event to test the cell and highlight the row.
Do you want all rows that have column C values that meet criteria highlighted or just the active row?
What are the criteria? Example workbook may help.
Was after all the rows that have these values in column C highlighted:
Itsnotifier, threatnotifier, emeremail, sharedemail, hostemail and offhostemail
I've got another macro i run first so I'll just stick it in there but I'm not sure how to work with colours in excel
Thanks
You would use code something like this
Please Login or Register to view this content.
Excellent, thanks Andy.
Have a good christmas!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks