Forum Discussion

JuneAC01's avatar
JuneAC01
Copper Contributor
Jun 13, 2023
Solved

Conditional Formatting and Blank Cells

Looking for some help please, didn't think this would be difficult but I cannot get it to work!  I am looking to use conditional formatting for a stock spreadsheet to highlight a date in Col F if th...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 13, 2023

    JuneAC01 

    Perhaps

    =($I$1="")*($F1 > TODAY()-60)

     for the rule formula 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 13, 2023

JuneAC01 

Perhaps

=($I$1="")*($F1 > TODAY()-60)

 for the rule formula 

JuneAC01's avatar
JuneAC01
Copper Contributor
Jun 16, 2023
🙂 Many thanks SergeiBaklan
That has worked beautifully 🙂
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 16, 2023

    JuneAC01 , glad to help.

    The only, it was misprint in formula, it shall be $I1, not $I$1

     

Resources