#1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 7
Default Highlight expiry date

Can anyone please tell me how to highlight a cell red if the expiry date
entered is within 6 months of expiring.
--
Kaz
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1,533
Default Highlight expiry date

Hi

You have to use conditional formatting.

With the date in A1 goto Format Conditional Formatting Condition 1:
Formula is Enter this formula in the empty field: =A1<TODAY()+DATE(0;6;0)

Format as desired OK OK

Hopes this helps

---
Per

"Karray" skrev i meddelelsen
...
Can anyone please tell me how to highlight a cell red if the expiry date
entered is within 6 months of expiring.
--
Kaz


  #3   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1,533
Default Highlight expiry date

The formula should be:

=A1<TODAY()+DATE(0,6,0)

Regards,
Per

"Per Jessen" skrev i meddelelsen
...
Hi

You have to use conditional formatting.

With the date in A1 goto Format Conditional Formatting Condition 1:
Formula is Enter this formula in the empty field:
=A1<TODAY()+DATE(0;6;0)

Format as desired OK OK

Hopes this helps

---
Per

"Karray" skrev i meddelelsen
...
Can anyone please tell me how to highlight a cell red if the expiry date
entered is within 6 months of expiring.
--
Kaz



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate expiry date Justina New Users to Excel 6 August 19th 11 07:20 PM
I want format cells to have expiry dates & highlight Aims Excel Worksheet Functions 1 January 21st 09 07:45 AM
VBA For Expiry date Alam Excel Discussion (Misc queries) 1 November 18th 07 12:36 PM
how to monitor/highlight upcoming expiry/due dates Saeed Excel Discussion (Misc queries) 3 November 10th 07 03:32 PM
Expiry date Martina Excel Worksheet Functions 6 February 11th 07 10:57 PM


All times are GMT +1. The time now is 10:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"