Highlight cell after 10 days

[ricwilli]

Hello all,

I am trying to find a Conditional Formatting formula to use in a column of cells with dates. I would like each cell, under the "Signed Out" column to turn red after 10 days of the date that is entered. I would like the cell to remain red until there is a date entered next to the red cell under the "Returned Date" column. Your help is gladly appreciated.

 

[Joe4]

Welcome to the Board!

Try this Conditional Formatting formula (written for row 2):

=AND(TODAY()-$B2>=10,$C2="")

 

[gordsky]

=AND($C4="",B4+10<TODAY())

change row number as needed (currently 4)

 

[ricwilli]

Welcome to the Board!

Try this Conditional Formatting formula (written for row 2):

=AND(TODAY()-$B2>=10,$C2="")

WOW!! Thanks. This worked.

Question. Do I have to add the formula to every cell individually or can I highlight the whole "Signed Out" column and add the formula? When I tried highlighting the column and adding the formula, the cells that had no dates turned red. The empty cell should remain white until a date is added and the formula can start working. Thank you once again.

 

[ricwilli]

=AND($C4="",B4+10<TODAY())

change row number as needed (currently 4)

Unfortunately this did not work.

 

[Joe4]

WOW!! Thanks. This worked.

Question. Do I have to add the formula to every cell individually or can I highlight the whole "Signed Out" column and add the formula? When I tried highlighting the column and adding the formula, the cells that had no dates turned red. The empty cell should remain white until a date is added and the formula can start working. Thank you once again.

Just select the whole range you want to apply it to, and write the formula as it applies to the very first cell in your selection, and Excel will adjust it for the rest.

To handle the blanks in column B, amend the formula like this:

=AND(B2<>"",TODAY()-$B2>=10,$C2="")

 

[ricwilli]

That worked. Thank you

 

[Joe4]

You are welcome.
Glad we were able to help!