Mike Echo

Posts: n/a

Conditional format with a formula

I have done this before but for the life of me cannot remember how I did
it.

Assume I have a column of dates. I want that column to be conditionally
formatted so that today's date will be red for example. I enter

=NOW()=1

in the formula for the conditional format but she no go. I tried TODAY
(), etc too.

Any ideas?

TIA,
R.

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 Format Formula Needed	PAR	Excel Worksheet Functions	11	May 20th 05 08:45 PM
copy conditional format to regular format	GDC	Setting up and Configuration of Excel	3	May 4th 05 09:35 PM
Conditional Format Question	DougS	Excel Worksheet Functions	3	May 3rd 05 01:36 AM
Conditional Format using value from another sheet	Joe Gieder	Excel Worksheet Functions	5	March 23rd 05 03:07 PM
Conditional Format	Norman Kong via OfficeKB.com	Excel Discussion (Misc queries)	3	March 23rd 05 10:31 AM

All times are GMT +1. The time now is 11:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us