Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-27-2022, 03:52 PM
rollis13's Avatar
rollis13 rollis13 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 2016
Competent Performer
 
Join Date: Jan 2021
Location: Cordenons
Posts: 142
rollis13 will become famous soon enough
Default

This could be your formula for cell B" with Conditional Formatting with red fill:

=IF(AND(B2=""),TODAY()-A2>30)
Reply With Quote
  #2  
Old 07-28-2022, 05:30 AM
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

That worked! Thanks a lot I really appreciate it!
Reply With Quote
  #3  
Old 07-28-2022, 05:34 AM
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

To take it one step further: Cells A2:A6 contain dates. Cells C2:C6 have letter grades (A, B, or C) I want Cells B2:B6 to be highlighted red if nothing is entered in to those cells after 30 days if they're an A, or 15 days if they're a B, or 7 days if they're a C. How do I do that?
Reply With Quote
Reply

Tags
conditional formatting, formula, rules failing



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 03:47 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