Thread: How do i highlight a cell red if no date has been entered 30 days after a date in another cell??
View Single Post
 
Old 07-28-2022, 05:34 AM
Daronovitz Daronovitz is offline Windows 10 Office 2019
Novice
  
Join Date: Jul 2022
Posts: 13
Daronovitz is on a distinguished road
Default
To take it one step further: Cells A2:A6 contain dates. Cells C2:C6 have letter grades (A, B, or C) I want Cells B2:B6 to be highlighted red if nothing is entered in to those cells after 30 days if they're an A, or 15 days if they're a B, or 7 days if they're a C. How do I do that?
Reply With Quote