Forum Discussion

Bobby M's avatar
Bobby M
Copper Contributor
Sep 08, 2017
Solved

Please Help!

I'm in the process of learning about Conditional Formating and I have a set up like this:   Cell A1 = Current date or todays date Cell B1 will = Overdue ( cell highlighted will=yes ) or ( cell bla...
  • SergeiBaklan's avatar
    Sep 08, 2017

    Hi Bobby,

     

    To highlight B1 add new rule:

    and apply it to the cell B1 only (here i took B2:B24 to generate the picture, in your case it'll be B2:B900)