A macro or command that can look at a range of numbers and assign a fill color to the cell

**dmackco** · 08-08-2012, 03:07 PM

I'm a new member, hope I did this correctly. I am working in a major California winery and presently designing a training program for our botttling lines. I would like to have a command that will look at a column of numbers from 0 to 5.0 and designate a fill color of my choice to four (4) ranges.

Thanks
Mack

**Tinbendr** · 08-08-2012, 04:06 PM

Welcome to the board!

Not sure if I understand completely, but have a look at conditional formatting.

**dmackco** · 08-08-2012, 07:39 PM

Works great and easy once you told me where to look. I will have to wait until Monday to apply this but thank you very much. I will also find out how to properly thank you and mark it solved, I'm home now.

**dmackco** · 08-13-2012, 10:12 AM

David: THANK YOU for the quick response and more importantly, the solution.

Mack

A macro or command that can look at a range of numbers and assign a fill color to the cell

LinkBack

Thread Tools

Rate This Thread

Display

A macro or command that can look at a range of numbers and assign a fill color to the cell

Re: A macro or command that can look at a range of numbers and assign a fill color to the

Re: A macro or command that can look at a range of numbers and assign a fill color to the

Re: A macro or command that can look at a range of numbers and assign a fill color to the

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions