IF conditions on dates

Microsoft Office: mac 2008 home and stud...
March 20, 2010 at 09:10:54
Specs: Macintosh
Hi there, I want to make a cell (G4) turn a certain colour
(red) if another cell date is less than or equal to today's
date. Using Office 2008 for Mac.
Many thanks

See More: IF conditions on dates

Report •

March 20, 2010 at 09:33:31

Use conditional formatting.

If the 'other cell' with a date in it is cell H4, then:
Select cell G4
From the Ribbon select Home - Styles - Conditional Formatting,
From the drop down select 'Manage Rules' and select 'New Rule'
In the dialog box select the last item in the list 'Use a formula to determine which cells to format'
Enter this formula in the box


Note that TRUE and FALSE do not have double quotes - they are Excel's logical values true and false.
Click the format button and from the 'Fill' Tab select a red color, click OK
Click OK again to exit CF.

Cell G4 will now change color based on the date in cell H4.

Note that the Integer function in the formula INT(H4) removes any time information from cell H$, so that only the date information is tested against Today's date.

Excel stores time in the decimal part of a number and date information in the integer or whole number part.


Report •

March 20, 2010 at 12:54:26
Many thanks, is this for windows excel or office 2008 excel for
I just don't see the 'ribbon' and assoc commands you mention.

Report •

March 20, 2010 at 13:38:47
For the Mac look under Format also look here:


That is one very long address

Here's a shorter one, but you'll have to find the Conditional Formatting section on your own.




Report •

Related Solutions

March 21, 2010 at 05:54:20

Thanks to Mike for providing pointers to "how to's" on Excel 2008 for Mac.

I mistakenly assumed that the 2008 version followed the style of the Windows 2007 version - but I see that it is more like the Windows 2003 version.

Spinifex - hope you got the CF working!


Report •

Ask Question