Macro to highlight cells. [Solved/Closed]

Question

Macro to highlight cells. [Solved/Closed]

Report

steveo0707

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

- Apr 30, 2013 at 11:42 AM
steveo0707

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

- 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.

Macro to highlight cells.
Excel - Macro to highlight Rows with Duplicate values in a cell ✓ - Forum - Excel
Assign Macro to all yellow highlighted cells ✓ - Forum - Excel
Macro to highlight a row if cells match value ✓ - Forum - Excel
Excel macro highlight cell based on value ✓ - Forum - Programming
Highlight at most 7 cells so that all unhighlighted cells are next to a highlighted cell - Forum - Excel

1 reply

Ask a question

rizvisa1 · Accepted Answer · 2013-05-04T11:31:28-0400

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

767
May 4, 2013 at 11:31 AM

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

Report

steveo0707

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

May 13, 2013 at 10:55 AM

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

Macro to highlight cells. [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!