Conditional Date Format

brian.hutchings@spsaerost · May 20th, 2002, 08:01 AM

I have calender headings from Jan to Dec in an Excel file. How can I get the current month to highlight. I know how to do the actual formatting but not how to get the formatting to recognise the current month.

Aladin Akyurek · May 20th, 2002, 08:05 AM

Quote:

On 2002-05-20 07:01, brian.hutchings@spsaerostructures.co.uk wrote:
I have calender headings from Jan to Dec in an Excel file. How can I get the current month to highlight. I know how to do the actual formatting but not how to get the formatting to recognise the current month.

How did you enter these 3-letter month names -- just e.g., Jan as text or as date?

brian.hutchings@spsaerost · May 23rd, 2002, 01:30 AM

Many thanks for replying. The dates are in three letter text format i.e. JAN FEB MAR

Tom Schreiner · May 23rd, 2002, 01:54 AM

Hi Brian.
Use a formula such as...



=IF($E$1=TEXT(NOW(),"MMM"),TRUE,)

If the text "MAY" was found in Cell E1, your formatting would be applied.
Make sure your condition is "Formula is" and not "Cell Value is".

To apply the formatting to like headers, remove the "$" before the "E" and the "1" and use your format brush to apply to other like cells which contain your other months.

Tom

[ This Message was edited by: TsTom on 2002-05-23 00:55 ]

brian.hutchings@spsaerost · May 27th, 2002, 02:20 AM

Tom, many thanks for the answer.
Regards, Brian Hutchings

[ This Message was edited by: brian.hutchings@spsaerostructures.co.uk on 2002-05-27 01:26 ]

May 23rd, 2002, 01:54 AM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Brian. Use a formula such as... =IF($E$1=TEXT(NOW(),"MMM"),TRUE,) If the text "MAY" was found in Cell E1, your formatting would be applied. Make sure your condition is "Formula is" and not "Cell Value is". To apply the formatting to like headers, remove the "$" before the "E" and the "1" and use your format brush to apply to other like cells which contain your other months. Tom [ This Message was edited by: TsTom on 2002-05-23 00:55 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 08:01 AM	#1
brian.hutchings@spsaerost New Member Join Date: May 2002 Location: Nottingham, England Posts: 14	I have calender headings from Jan to Dec in an Excel file. How can I get the current month to highlight. I know how to do the actual formatting but not how to get the formatting to recognise the current month.

May 23rd, 2002, 01:30 AM	#3
brian.hutchings@spsaerost New Member Join Date: May 2002 Location: Nottingham, England Posts: 14	Many thanks for replying. The dates are in three letter text format i.e. JAN FEB MAR

May 27th, 2002, 02:20 AM	#5
brian.hutchings@spsaerost New Member Join Date: May 2002 Location: Nottingham, England Posts: 14	Tom, many thanks for the answer. Regards, Brian Hutchings [ This Message was edited by: brian.hutchings@spsaerostructures.co.uk on 2002-05-27 01:26 ]