Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a problem on conditional formatting with date and time.

I have a cell A1 that has date and time and I want to conditionally format its adjacent cell if the value of cell A1 is greater than 3 days compared to today. Cell A2 should show as "Follow-up Required" and cell colour should turn red. If cell value of A1 is less than 3 days compared to today, no action is required.

share|improve this question
add comment

2 Answers

You can use conditional formatting "Use formula to determine which cells to format.

I don't completely understand your requirement but doing something like this in your adjacent cell should do it.

conditional format

The key concept here is that conditional formatting requires a true/false input. Most of the time we want to conditionally format based on the value in the cell itself. However using the formula section allows the format of any cell to be determined by any formula that evaluates to true or false.

share|improve this answer
add comment

Very similar to @Pynner's answer, but addresses " Cell A2 should show as "Follow-up Required". Enter:

=IF(NOW()>A1+3,"""Follow-up Required""","")  

in A2 and copy down (assuming you have several 'A1' dates). This provides the required text and can also be used for the conditional format, with "Format only cells that contain" and Cell Value equal to ="""Follow-up Required"""
Note that NOW() may need to be refreshed (eg F9) and this takes '3 days' as 72 hours.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.