Posted to microsoft.public.excel.misc

Jeri

external usenet poster

Posts: 5

Excel 2007 comparing dates

I have two columns and I want to compare the dates in the columns and then
format the cell to be to Red if column B is greater than column A.

So far, it seems that I can only do this on a per cell basis and not for the
whole column. Excel 2007's conditional formating is much harder for me to
get used to. Any help you could provide would be appreciated.
--
Thank you.

Jeri

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
Comparing Dates	fubdap	Excel Discussion (Misc queries)	3	September 27th 07 03:53 PM
comparing excel 2003 and excel 2007	tjccs4	Excel Discussion (Misc queries)	4	February 12th 07 02:06 PM
Comparing 3 dates	Steve	Excel Worksheet Functions	1	May 9th 06 12:10 PM
Comparing dates	Debbie F	Excel Worksheet Functions	7	September 7th 05 11:57 AM
Comparing dates in an IF function	Paula	Excel Worksheet Functions	3	January 12th 05 02:21 PM

All times are GMT +1. The time now is 08:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us