Mark concrete day before end

[Jose123456]

Hi guys i have some table with days of expiration. I would like to ask if it possible to varnning me one mount before that expiration comming. For example in the concrete cell with date change color or something like that. Thank you for your advices

[Pete_UK]

You would normally use Conditional Formatting to do that, using a formula that compares the date in the cell with the function TODAY().

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

[Jose123456]

You would normally use Conditional Formatting to do that, using a formula that compares the date in the cell with the function TODAY().

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

ok Pete i uloaded woorkbook. It would be great if you do that

[JohnTopley]

Try

in Conditional Formatting (CF)
..Use a formula ...

=$A3-$C$1 < TODAY()

Where C1 is number of days "warning" required.

Set FILL colour to ORANGE

I added another CF

=$A3 < TODAY()

Set FILL colour to RED

A66 added as example


And please do not quote whole posts when replying: it is just "clutter"

[Roel Jongman]

You can do that with conditional formatting (CF)

I used this formula in CF
=AND(TODAY()+$D$1>=$A3,ISBLANK($B3))
advantage is that is also tests if an end date was filled in column B
it is an assumption I made that at some point you want the have the CF go away when a exparation is handeled (either ended or

You could also use
=TODAY()+$D$1>=$A3
this will highlight any date that is within X days of the set days of exparation in Cell D1.
I used a cell reference to make the formula flexible but offcourse you can also replace D1 reference with fixed number of days

see attachement