How do i Grey out cells when the date does not equal todays date?

Hi and welcome to the forum.

Check out conditional formatting. Use the 'Use a formula...' option and use a formula like

Formula:

Please Login or Register  to view this content.

where column A is the column containing the dates. Define the formatting you want and apply it to the column of cells.

Try this in the attached.

Yellow the range in question as the default stand-out range.

Then apply this Conditional Format formula to that same range.

Formula:

Please Login or Register  to view this content.

Formatted with a greyed-out background.

Does this do what you want?

Hi,

Pictures are rarely much use. You have a workbook so upload it in order that we can see your request in context.

Maybe not. Excel may be able to read it. But of course this is an Excel forum not a Google docs forum. If GD has conditional formatting functionality then there's a chance it's similar to Excel but we'll only know when we have sight of the file, which makes it even more important that we see the file. You should perhaps have mentioned this in your first post?