Conditional format 2007 - is this easy?

UlfHJensen

Guest

Posts: n/a

24th Nov 2009

In prior versions, I would easily have been able to do the below. But how do
I do it in 2007 Excel? I really cannot figure it out...
Situation:
I have a table; 5 columns, X rows.
Column 4 contains a date (dd-MM-yyyy) or is blank (I have received no date
to enter from client).
If cell in column 4 i blank or date is later than TODAY(), I want all cells
in the table-row to be font-colour black and if date has passed (TODAY>date)
I want font-colour to be red.
How to do - in a simple way - using conditional formatin Excel 2007?

--
Best regards
Ulf

« Convert excel file to xml | Windows Installer loads every time I open Excel 2007 »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Format-should be an easy answer	Kimbatigger	Microsoft Excel Discussion	1	17th May 2011 03:35 PM
Conditional Format 2007	Paula	Microsoft Excel Worksheet Functions	1	16th Sep 2009 03:52 PM
Is there an easy way to set up Word 2007 for MLA format?	questmom	Microsoft Word New Users	3	3rd Aug 2009 08:37 AM
How to conditional format in 3 colors in 2007	TES	Microsoft Excel Misc	1	8th May 2009 08:57 PM
Conditional Format Excel 2007	Sue	Microsoft Excel Programming	2	23rd Dec 2008 10:01 AM