Function Excel:If a Date>actual date create a RED alert in a cel?

[Guest]

How do I can create a function that:

IF a Date > Actual Date Then
Show a Red Cel
Else
Show a blue Cel
If else

 

[Joerg]

You can't use a function (since functions cannot change formats) and you
don't need one: Use Conditional Formatting instead.
To turn cell A1 red whenever the value is >actual select Conditional
Formatting from the Format menu, then for condition1 select "formula is",
then type in following formula: =A1>NOW()
Choose your format for this condition (red color cell shading) and push OK.
That's it! If you want the cell to be blue in all other cases, just format
it as normal.

You can copy this cell as needed. The conditional formatting will be copied
along.

Cheers,

Joerg Mochikun