Range of Cells Color Change depedent on another Cell!

[mdmorgan]

Hi Everyone,

I dont' know much about VBA but I need cells D14 & 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]

You can use conditional formatting for this, use the formula Is option and use this formula: =$B$2>0