Microsoft Office Forums - View Single Post - Auto enter data based on formula in another cell?

Thread: Auto enter data based on formula in another cell?

View Single Post

Old

06-30-2017, 10:10 AM

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

You would have to enter an IF() formula in the cells additional to the Conditional Formatting you did...

so in the same cells you would enter formula:

=IF(AND(F4>=TODAY()-305,F4<=TODAY()),"Up to Date","Past Due")

Reply With Quote