Help me set specific formulaic rules to conditionally format cells

Daronovitz · #1 07-22-2022, 10:32 AM

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!

justa_guy_32405 · #2 08-06-2022, 02:57 PM

Select a new rule, then the use formula is true

Code:

=TODAY()-C1>5

Then just go to formatting the background

p45cal · #3 08-07-2022, 05:43 AM

To highlight only empty cells a formula along these lines:
=AND(A2="",$C2<TODAY()-5)
See attached.

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