Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-27-2022, 12:47 PM
Daronovitz Daronovitz is offline How do i highlight a cell red if no date has been entered 30 days after a date in another cell?? 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
How do i highlight a cell red if no date has been entered 30 days after a date in another cell??
 
Join Date: Jul 2022
Posts: 13
Daronovitz is on a distinguished road
Default How do i highlight a cell red if no date has been entered 30 days after a date in another cell??

Example: Cell A2 contains the date 6/1/22. I want Cell B2 to be highlighted red if nothing is entered in to cell B2 after 30 days. How do I do it?
Reply With Quote
 

Tags
conditional formatting, formula, rules failing

Thread Tools
Display Modes


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
How do i highlight a cell red if no date has been entered 30 days after a date in another cell?? 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 12:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft