conditional formatting

[Dan Rubinsky]

Need a magic formula to use in Conditional Format. As soon as I enter
date and if it is the actual date (now()) the cell must be formate
with dark blue and white text. If the date changes the cells in blu
must change to normal cells color.
Perhaps a funtion in format condition is not the solution ... maybe
VBA macro.
Thanks


Dan
(e-mail address removed)

 

[Bob Phillips]

Use the condition 1 as a Formula Is , and this formula

=A1=TODAY()

format as required.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Don Guillett]

try conditional format>formula
=c9=and(c9<>" ",isnumber(c9),c9=today())

 

[Bob Phillips]

Bit of overkill isn't it Don?

If it is TODAY, it will be a number, and it won't be space, so it just needs
the one test.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

try conditional format>formula
=c9=and(c9<>" ",isnumber(c9),c9=today())

 

[Don Guillett]

Hey, if one glass of red wine is good, more is better.

--
Don Guillett
SalesAid Software
(e-mail address removed)

Bit of overkill isn't it Don?

If it is TODAY, it will be a number, and it won't be space, so it just needs
the one test.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Lol! Can't argue with that.

Bob

Hey, if one glass of red wine is good, more is better.

--
Don Guillett
SalesAid Software
(e-mail address removed)
enter