If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA to check if cell is highlighted

Thread starter jiggaman84
Start date Sep 3, 2013
Tags

highlight cells test if highlighted vba highlight cells

jiggaman84

New Member

Sep 3, 2013

Real easy question... Cell C10 has the favorite team. Cell D10 has the underdog team. What I'd like is a macro that will test whether or not Cell C10 is highlighted (any color). If so, Cell E10 should automatically be "1", if not highlighted, E10 is "2".

Hope this is straight forward enough. Looking forward to your response.

jiggaman