Lenze, thank you for the macro (hope you didnt write that just for me)
(and I know I am a pain in the you know what) BUT since my sheet is for stock related information, i wanted different shades of reds that get more intense as the columns values become more and more negative(from my indicators) and different shades of green based on how it is progressing, so currently it shows RED while the values are actually getting better then it will jump to a grey(neutral) or Green(bullish) thats why i was looking for I guess a customizable palette with different shades of the same color BUT with the color index numbers I can use within a CASE Macro..doesnt seem to be available, i did numerous searches on the 'net...
thank you for always offering some help!