Home » Forums » Open Source Learning Center » Question and Answer

conditional formatting with date and time

Submitted by kiranpat on 8 December, 2012 - 20:59

Hi all,

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

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

Please help.

Regards,
Kiran

‹ Automating allotment VLOOKUP formula ›
»

RE: Conditional formatting with date and time

Submitted by manny on 9 December, 2012 - 14:29.

Hi,

Select cell A2 and enter your text message: "Follow-up Required". Then format the cell's Font Color with same color as cell's background color. This will make the cell value to be "invisible". Afterwards, go to Conditional formatting -> New Rule... -> Use a formula to determine which cells to format and enter the following formula:

 = (A1 > (NOW() + 3))

Choose desired format for the cell when condition is True - in your case select red background color.

 

Best regards.

»

Thanks Manny... it worked...

Submitted by kiranpat on 9 December, 2012 - 17:34.

Thanks Manny... it worked...

»