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??

FAQ

Thread Tools

Display Modes

#10

07-29-2022, 09:32 AM

Daronovitz Daronovitz is offline

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

Office 2019

Novice

Join Date: Jul 2022

Posts: 13

That worked! That was my issue was putting the numbers in "" instead of excluding. Once a date is entered I want the red fill to disappear which your formula does, so I am officially a go! Thank you so much for your patience and help!

Tags

conditional formatting, formula, rules failing

« Previous Thread | Next Thread »

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 07:57 PM.