Conditional Formatting help....formula based...

[aama]

Hello,

I need help on conditional formatting. In coloumn "P" in my excel sheet I want to apply conditional formating where if that sum total does not exceed or is less than the total of columns "A + B + C +D". I would like the colour to highlight when it does exceed or less than those amounts in red....can anyone help me. It is a newbie question and appreciate if someone can help me so I can learn and get better in excel...thanks...

 

[Hui]

Aama

Firstly, Welcome to the Chandoo.org Forums

Select P5: P100 or the bottom of your data
Goto the Home, Conditional Formatting Tab
Select New Rule, Use a Formula
Enter the Formula: =P5<sum(A5:D5)
Select a Format
Apply

Excel adjusts the CF for all other rows

enjoy