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

Hi, 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=IF(INT(H4)<=TODAY(),TRUE,FALSE)

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.

Regards

Many thanks, is this for windows excel or office 2008 excel for

mac?

I just don't see the 'ribbon' and assoc commands you mention.

For the Mac look under Format also look here: http://www.microsoft.com/mac/help.m...

That is one very long address

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

http://www.microsoft.com/mac/help.m...

MIKE

Hi, 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!

Regards

Ask Your Question

Weekly Poll