Macro for color coding

P

pdgarza

I think I need to create a macro but i'm not real sure how or even if this
is what I need to do. Here is what I am trying to do:

The following information is in an excel spreadsheet:

Column Q Col R Col S
Col T
Actuals Budget Var. to Budget %
Var. to Budget
75.36 84.00 8.64
10.29%

$ 6,255,588 $ 7,047,249 $ 791,661 11.23%
1,285,656 1,452,863 167,207 11.51%
7,541,244 8,500,112 958,868 11.28%

- - - 0.00%
47,957 157,369 109,412 69.53%
149,288 230,600 81,312 35.26%
174,510 227,455 52,945 23.28%
41,359 107,800 66,441 61.63%
62,133 71,676 9,543 13.31%
475,247 794,900 319,653 40.21%

$ 8,016,491 $ 9,295,012 1,278,521 13.75%

If the numbers in Column T fall within a certain range, the number in column
T has to be color coded as follows:
10% Blue
2% to =10% green
-2% to 2% gold
anything greater than -2 red

The entire row, needs to be color coded the same color as the number in
column T (regardless of the range that numbers in Q-S fall under).

Any suggestions on how or even if this can be done.

Thanks!
 
J

JMay

You could Format ALL the %'s in COlumn T as Gold (-2 to + 2 - less volitile)
Then use the limit of the 3 Conditional Formatting options for the Blue,
Green and Red - utilizing the CellValue option Greater than, Between and Less
than
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top