(ieHi,
I dont know if this is possible,
But, what i would like to do is thus,
I have a cell with a figure in, ie, 24.7 (cell B3)
and I have three columns with some figures in, each column indicates a certain percentage, ie, col E (24-30%) col F (31-35%) and col G (36%+)
Depending on what value is defined in cell B3 (ie, 24.7) i want the figuresin the corresponding column (ie, col E) to be highlighted with say a border around the cells which contain the figures in that column.
(additional info: cols E,F,G have data entered into rows 6-40)
Bookmarks