Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
color coding | Excel Discussion (Misc queries) | |||
Color coding cells | Excel Discussion (Misc queries) | |||
Color Coding Cells | Excel Worksheet Functions | |||
color coding | Excel Worksheet Functions | |||
Color coding | Excel Discussion (Misc queries) |