Forum Discussion

SmithJM157's avatar
SmithJM157
Copper Contributor
Mar 20, 2022

Conditional Formatting Blank Cells

I am needing a rule that will allow me to highlight blank cells yellow if they are less than 30 days from the date in Column A.  Then change to red if it goes past the 30 day mark, until data is ente...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Mar 20, 2022

SmithJM157 

Select the range D2:U17 (or further to the right and down if necessary).D2 should be the active cell in the selected range.

 

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula

=AND($A2<=TODAY(),D2="")

Click Format...

Activate the Fill tab.

Select yellow.

Click OK, then click OK again.

 

Repeat these steps, but with the formula

=AND($A2<=TODAY()-30,D2="")

and red as fill color.

SmithJM157's avatar
SmithJM157
Copper Contributor
Mar 20, 2022
Thank you for the response. I highlighted the columns that I need the formulas applied to, and have built the rules as shown and it does not appear to be doing it correctly for me.
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Mar 20, 2022

    SmithJM157 

    Please attach a sample workbook demonstrating the problem, or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar.

    • SmithJM157's avatar
      SmithJM157
      Copper Contributor
      Mar 20, 2022

      HansVogelaar hopefully this link works correctly. 

       

      https://docs.google.com/spreadsheets/d/1YJnQT9QHk9jX5sCkaDzM_bn1UQ5jrSgS/edit?usp=sharing&ouid=100103939138852560324&rtpof=true&sd=true

Resources