Posted to microsoft.public.excel.worksheet.functions

jazzydwit

Posts: n/a

conditional formatting

hi.
now that i have one issue down, another pops up. i need help now with
adding conditional formatting when i enter a formula to highlight
column dates <= to a particular date. what i am doing is highlighting
the entire column that i want to add the conditional format too, then i
enter the formula =IF(E3<=DATE(2005,1,4),"yes","no") add my format and
nothing happens. Please help. 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
Conditional Formatting when inserting a row	zahoulik	Excel Worksheet Functions	2	January 7th 06 03:01 PM
Conditional Formatting Error	ddate	Excel Worksheet Functions	0	May 5th 05 09:00 PM
difficulty with conditional formatting	Deb	Excel Discussion (Misc queries)	0	March 23rd 05 06:13 PM
conditional formatting question	Deb	Excel Discussion (Misc queries)	0	March 23rd 05 02:07 AM
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:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us