Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-22-2022, 10:32 AM
Daronovitz Daronovitz is offline Help me set specific formulaic rules to conditionally format cells Windows 10 Help me set specific formulaic rules to conditionally format cells Office 2019
Novice
Help me set specific formulaic rules to conditionally format cells
 
Join Date: Jul 2022
Posts: 13
Daronovitz is on a distinguished road
Question Help me set specific formulaic rules to conditionally format cells

I need help. I am a fairly new user to Excel but have increased my proficiency in a short time.



I have a spreadsheet where I have a column (call it column C) dedicated to the date a work order was received, and I want to highlight empty columns in the cell next to it when more than 5 days has passed since the date in column C.

How do I set the rule and formula for this? Thank you!
Reply With Quote
  #2  
Old 08-06-2022, 02:57 PM
justa_guy_32405 justa_guy_32405 is offline Help me set specific formulaic rules to conditionally format cells Windows 7 64bit Help me set specific formulaic rules to conditionally format cells Office 2010
Novice
 
Join Date: Jul 2022
Posts: 16
justa_guy_32405 is on a distinguished road
Default

Select a new rule, then the use formula is true

Code:
=TODAY()-C1>5
Then just go to formatting the background
Reply With Quote
  #3  
Old 08-07-2022, 05:43 AM
p45cal's Avatar
p45cal p45cal is offline Help me set specific formulaic rules to conditionally format cells Windows 10 Help me set specific formulaic rules to conditionally format cells Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

To highlight only empty cells a formula along these lines:
=AND(A2="",$C2<TODAY()-5)
See attached.
Attached Files
File Type: xlsx msofficeforums49388.xlsx (10.5 KB, 2 views)
Reply With Quote
Reply

Tags
conditional_formula, formula, rules

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help me set specific formulaic rules to conditionally format cells Conditionally Shade Table Cells S7ewie Mail Merge 8 04-29-2021 01:52 AM
VBA to conditionally format table lmoir87 Word VBA 2 08-23-2019 03:42 AM
Help me set specific formulaic rules to conditionally format cells Macro to delete text from cells with specific format Soenke Word VBA 4 09-01-2016 08:55 AM
Help me set specific formulaic rules to conditionally format cells How to conditionally format cells in Col. A if it matches adjacent cell in Col. B? alshcover Excel 2 06-03-2014 12:50 PM
Help me set specific formulaic rules to conditionally format cells How to conditionally format this? g4tv4life Excel 2 03-13-2014 10:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:23 AM.


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