Macro to highlight cells. [Solved/Closed]

Report
Posts
2
Registration date
Tuesday April 30, 2013
Status
Member
Last seen
May 13, 2013
-
Posts
2
Registration date
Tuesday April 30, 2013
Status
Member
Last seen
May 13, 2013
-
I am very new to VBA and have spent countless hours looking for help on the web.

I have a worksheet with 100,000 rows(locations) and 34 columns(Channels).

I need a code to test for 5 levels of criteria.

Level 1 and Level 2 I have figured how to get the cells highlighted.

I cannot figure out how to get it to highlight the cells for Level 3, 4 and 5.

Level 1 highlights the cells green when the MF signal is <= 25 and US Thickness is >=9.0

Level 2 highlights the cells yellow when the MF signal is > 25 and < 90 and US Thickness is < 9.

Level 3 needs to scan the data for level 2 conditions for both MF and US in adjacent cells (up,down,side to side, and diagonally) and highlight those cells light orange.

Level 4 scans for Level 2 conditions for both MF and US for the same channel and location and highlight those cells bright orange.

Level 5 checks for multiple level 4 events in adjacent locations and highlight cells red.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
Is it possible to get a sample sheet posted at some public file share site and you posting a sample book to show what you want to do
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Tuesday April 30, 2013
Status
Member
Last seen
May 13, 2013

Hello rizviasa1,

Sorry it took so long to get back to you. I have been super busy with work and school. I was able to get this problem figured out. Thank you for your response.

Thank you for your time!

Sincerely,

Stephen Meiring

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!