SMac

Posts: n/a

Conditional Formating based on another cell

I have 2 columns of concern DATE and COST.
I would like the COST cell to be shaded if the DATE cell is less than a
specificed date.
Then if it is possible to calculate the COST field but only the ones
highlighted.

Help is greatly appreciated!!

Thanks, Stacey

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 formating - cell protection	Bdavis	Excel Discussion (Misc queries)	0	February 11th 05 09:15 PM
Can you conditional format based on information in cell comments?	Jflyer	Excel Worksheet Functions	1	January 15th 05 01:52 AM
How to do a conditional formatting based on an adjacent cell	Confused	Excel Discussion (Misc queries)	2	January 10th 05 09:55 PM
cell formating based on value	Carl Hilton	Excel Worksheet Functions	3	January 9th 05 07:39 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 01:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us