Vba to fill in row colour by cell value taking colour from a grath (range)

tonywatsonhelp

Well-known Member
Joined
Feb 24, 2014
Messages
2,785
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
Hi Everyone,

I'm trying to create a list of customers and how long they have been waiting then colour code then green to red
What I was thinking is to create a graph area where i put my criteria and have vba macro look at each row in the list and colour code the list according to the rules in the graph, but I'd like it flexible in the number of options if possible?

So for example. lets say my list is H30:K30 and Column K has values in it (the amounts will vary but will start at no lower than 1)

So Column K has lots of numbers

theres a graph or grid area where i have the critiriea

Say Column A is the start number, B is the Fin Number and C is the colour?

Like This

ABC
FromToColour
13This cell is filled with a colour eg. Green
46so the colour of the cell is the colour to choose
712
12above?I'm not sure how many rows i'd like so if we could make this flexable then great, I put above but happy to set this up as you need it.
So hopefully this is clear but it a macro that looks at the number in column K find that number in the above area and makes the rows that colour

thanks
Tony
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Forum statistics

Threads
1,136,323
Messages
5,675,087
Members
419,549
Latest member
EliteBeat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top