steveo07072
Posts Tuesday April 30, 2013Registration date
May 13, 2013
Last seen
-
Apr 30, 2013 at 11:42 AM - Latest reply: steveo07072
Posts Tuesday April 30, 2013Registration date
May 13, 2013
Last seen
- May 13, 2013 at 10:55 AM
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.
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.
has helped 1675 users this month
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