Posted to microsoft.public.excel.misc

housinglad housinglad is offline

external usenet poster

Posts: 19

Conditional Formating Help

Hi

I wonder if anyone could help me, I am after code for the following.

cell e6 = Keys Sent
Column f6 = Keys due
Column g6 = Keys received

What I want the script to do is if there is no value in g6 and todays date
is greater then the date stated in F6, then the cell turns red (prompt to
inform me that keys are late).

Many thanks
Dan

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	Kath	Excel Worksheet Functions	6	January 7th 09 08:13 PM
Conditional formating	Ryan	Excel Discussion (Misc queries)	3	August 20th 08 08:17 PM
Conditional Formating	carl	Excel Worksheet Functions	1	September 12th 07 05:03 PM
conditional formating	[email protected]	Excel Discussion (Misc queries)	2	April 22nd 06 06:19 PM
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM

All times are GMT +1. The time now is 04:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us