How do i highlight a cell red if no date has been entered 30 days after a date in another cell??

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How do i highlight a cell red if no date has been entered 30 days after a date in another cell??

07-28-2022, 11:03 AM

rollis13

Windows 10 How do i highlight a cell red if no date has been entered 30 days after a date in another cell??

Office 2016

Competent Performer

Join Date: Jan 2021

Location: Cordenons

Posts: 143

See if I got it right:

=OR(AND(C2="A",TODAY()-A2>30),AND(C2="B",TODAY()-A2>15),AND(C2="C",TODAY()-A2>7))

Tags

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula for looking at 1 cell with a date and then comparing it to four date ranges	LearningMom	Excel	3	10-27-2017 12:44 PM
Need help with using traffic lights in one cell based on date value in a different cell	wmedjaxnjr	Excel	1	04-09-2016 04:22 PM
calculate date if date entered in cell, do nothing if blank	ConfuddledOne	Excel	3	11-07-2014 09:37 AM
Make table cell active add date count date	MelHerndon	Word VBA	3	01-21-2013 04:23 PM
How can I make a cell color RED under the Today's date cell?	Learner7	Excel	2	07-08-2010 12:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:37 PM.