#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Select a new rule, then the use formula is true
Code:
=TODAY()-C1>5 |
#3
|
||||
|
||||
To highlight only empty cells a formula along these lines:
=AND(A2="",$C2<TODAY()-5) See attached. |
Tags |
conditional_formula, formula, rules |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Macro to delete text from cells with specific format | Soenke | Word VBA | 4 | 09-01-2016 08:55 AM |
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 |
How to conditionally format this? | g4tv4life | Excel | 2 | 03-13-2014 10:58 AM |