Recent content by Neanie

I know it's been a while... This project was a "do as you have time" project. I was finally able to get back to it and try out your suggestions. Now it is my turn to thank you all for your assistance and let you know that Glenn's code worked like a charm. I could not have done this without...

I understand what you each are saying. The only thing, I use white as a "color" too. Therefore, I technically have 5 conditions: blank = gray 90% - 100% = green 70% - 90% = white 50% - 70% = yellow >50% = red I have found that using absolute referencing helps but once the color is set, it...

Skip, Let me see if I understand your previous post correctly: Select A1:B2 Format the interior for the default format. Format CF =H15="" for your first criteria and continue thru your remaing three. I should use the tradition...

My apologies, Skip. I got side tracked yesterday and am finally able to get back to this project. I hadn't noticed you made another suggestion. I will try it now. Thanks! Jeannine

I have fours cells in a worksheet, each referencing a different cell within the same worksheet. I need to have each target cell change color (red, green, yellow, white or gray) depending on the value found in the referenced cell. When I use the traditional code (below), the color will not...

The four cells reference four seperate cells: A1 references H15 A2 references H16 B1 References I15 B2 references I16 As the values change is H15:I16, the colors do not change in A1:B2. The code above only works if the values are changed directly in the targeted cells A1:B2. I hope this...

I have found a lot of VBA on how to code conditional formatting for more than 3 conditions, all of which are conditioned on the information within the cell. I have fours cells in a worksheet, each referencing a different cell within the same worksheet. I need to have four conditions to change...