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, 08:14 AM

RonLEngle

RonLEngle is offline

RonLEngle uses Windows 7 32bit

Windows 7 32bit RonLEngle uses Office 2010 32bit

RonLEngle uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Jun 2017

Posts: 8

RonLEngle is on a distinguished road

Default

This is the exact Formula used in the Status Column of spreadsheet and it changes the color as i need based on date entry in source cell, but i also want it to autofill " Up to Date" at same time

=AND(F4>=TODAY()-305,F4<=TODAY())

is this possible?

Reply With Quote