Posted to microsoft.public.excel.worksheet.functions

Helen Holubowicz Helen Holubowicz is offline

external usenet poster

Posts: 6

Conditional Formatting question

Hi I have a list of dates that will be entered, i have already a formula
that will calculate say 2 years on from the date, but i need the conditional
formatting to change the font to show me the dates from a month in advance,
In the dialog box i have tried

1. =today
2. between =today and =today+31

but im getting intermittent results, can anyone help?

Ta

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Conditional Formatting Question	mwevans1234	Excel Worksheet Functions	2	May 24th 06 10:37 PM
Tough conditional formatting question	jezzica85	Excel Discussion (Misc queries)	8	April 8th 06 01:38 AM
enhanced conditional formatting	Stuart	Excel Discussion (Misc queries)	13	November 13th 05 07:20 PM
Conditional Formatting Error	ddate	Excel Worksheet Functions	0	May 5th 05 09:00 PM
Conditional formatting not available in Excel	BAB	Excel Discussion (Misc queries)	2	January 1st 05 03:33 PM

All times are GMT +1. The time now is 06:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us