PDA

View Full Version : Range of Cells Color Change depedent on another Cell!



mdmorgan
09-27-2010, 08:58 PM
Hi Everyone,

I dont' know much about VBA but I need cells D1:D4 & F1:F4 to change from white to blue, if Cell B2 is greater than 0! I find many people want to change just one cell if it meets criteria, but I need to have it based off another cell and a range to change color!

Any Help would be much appreciated!

Matt

Jan Karel Pieterse
09-27-2010, 11:00 PM
You can use conditional formatting for this, use the formula Is option and use this formula: =$B$2>0