Column Possible

's Computer Specifications

Is it possable to have a cell compare the cell date to "Today" and if
"Today" is older then the cell then turn the cell red with white
letters.

TIA
Tango

's Computer Specifications

Yes, use conditional formatting with a formula of

=C1>TODAY()

See http://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Tango" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Is it possable to have a cell compare the cell date to "Today" and if
> "Today" is older then the cell then turn the cell red with white
> letters.
>
> TIA
> Tango
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calendar Spreadsheet: Column 1 = Date, Column 2 Time of Day, Column 3 memo text field	JDJ	Microsoft Excel Discussion	0	24th May 2007 01:14 AM
Search for a column based on the column header and then past data from it to another column in another workbook	minkokiss	Microsoft Excel Programming	2	5th Apr 2007 01:12 AM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row >> look	MPSingley@midamerican.com	Microsoft Excel Programming	2	30th Dec 2006 06:23 PM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row >> look	MPSingley@midamerican.com	Microsoft Excel Misc	0	27th Dec 2006 04:31 PM
How can i have all alike product codes in column A be matched with like cities in column B and then add the totals that are in column C	genesisoxygen@gmail.com	Microsoft Excel Programming	4	2nd Aug 2006 01:10 AM