Posted to microsoft.public.excel.programming

external usenet poster

Posts: 240

vb needed i think...

I'm usually quite good with conditional formatting but I don't think it can
handle what I need.
Let's say in cell A1 I have a date.
In cell A3 I have the conditional format =(TODAY()-A128) shade in red.
(If it's more than 28 days from the date show me in red)

If I enter a date in cell A2 then I want the conditional format to be ignored.
Can this be done with conditional formatting or will it take VB?
If it's VB what would you suggest?

Thanks.

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
Deleting Rows With Non-Needed Data between Needed Data	Daren	Excel Worksheet Functions	2	September 30th 08 06:47 PM
MCT Needed	Reggie	Excel Discussion (Misc queries)	0	August 12th 07 07:22 AM
More IF help needed	Michell Major	Excel Discussion (Misc queries)	2	November 13th 06 04:38 PM
Help needed...	l.o.c.o.s	Excel Discussion (Misc queries)	9	February 5th 06 03:49 AM
help needed	zomex	Excel Worksheet Functions	5	January 4th 06 12:54 PM

All times are GMT +1. The time now is 02:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us