Microsoft Office Forums - View Single Post - [Solved] Conditional color fill based on presence of data

Thread: [Solved] Conditional color fill based on presence of data

View Single Post

Old

07-27-2011, 07:51 PM

Catalin.B

Catalin.B is offline

Catalin.B uses Windows Vista

Windows Vista Catalin.B uses Office 2007

Catalin.B uses Office 2007

Office 2007

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Catalin.B is on a distinguished road

Default

Just add new rule, select the range A4:C100, open conditional formatting, add new rule, select to use formula, and the formula to format is:
=sum(H4:Q4)<0, and the color to format is obviously, grey

Reply With Quote