ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional format 2007 - is this easy? (https://www.excelbanter.com/excel-discussion-misc-queries/249251-conditional-format-2007-easy.html)

UlfHJensen

Conditional format 2007 - is this easy?
 
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 (TODAYdate)
I want font-colour to be red.
How to do - in a simple way - using conditional formatin Excel 2007?

--
Best regards
Ulf


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com