Microsoft Office Forums - View Single Post - [Solved] Formula to format "I" column based on if "F" column row is not blank

Thread: [Solved] Formula to format "I" column based on if "F" column row is not blank

View Single Post

Old

08-21-2017, 01:41 PM

NBVC

NBVC is offline

NBVC uses Windows 10

Windows 10 NBVC uses Office 2013

NBVC uses Office 2013

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

NBVC will become famous soon enough

NBVC will become famous soon enough

Default

Assuming you are selecting from I2 down...

=AND($F2<>"",LEFT($F2,5)<>"Total")

This should colour column I if F is not blank and it is not a Total row...

If you want Total row coloured, then simply use

=$F2<>""

Reply With Quote