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