Thread: Help me set specific formulaic rules to conditionally format cells
View Single Post
 
Old 08-07-2022, 05:43 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
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