Hello,
I'm not finding the answer I'm looking for.
I would like to use conditional formatting for a row B6:F31. Looking for if cell B is less than or equal to today's date then color the row using conditional formatting.
I'm not having luck to get this to work. I also display the current date in cell: P50, I have tried to do if B is less than or equal to P50 but could not get that to work. P50 is formatted as mm/dd/yyyy and column B is formatted as ddd mm/dd/yyyy.
Thanks,
Bdenn
I'm not finding the answer I'm looking for.
I would like to use conditional formatting for a row B6:F31. Looking for if cell B is less than or equal to today's date then color the row using conditional formatting.
I'm not having luck to get this to work. I also display the current date in cell: P50, I have tried to do if B is less than or equal to P50 but could not get that to work. P50 is formatted as mm/dd/yyyy and column B is formatted as ddd mm/dd/yyyy.
Thanks,
Bdenn