Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
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
 

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 06:09 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