Trouble with IF function part 2

[Ecruse]

Today apparently isn't my day for IF functions.

What I'm trying to do is this function calculation for cell AC if cell S6 is blank then insert function (NOW) & if possible highlight cell pale yellow, if S6 contains data /text then =S6.

Any and all help is appreciated.

Eric

[BrownBoy]

Ecruse,

In AC try:

=IF(ISBLANK(S6),NOW(),S6)

Conditional formatting for AC:

=LEN(S6)>0

[Ecruse]

Thank You the IF statement works perfect, not sure how to apply the conditional formatting so that it only effects the cells where NOW was applied.

[BrownBoy]

For the formatting try:

"Home" tab > "Styles" group > "Conditional Formatting" > "New Rule > "Use a formula to determine which cells to format" > enter the formula and adjust the format > click "OK"

[ChemistB]

A point of information, the NOW() function will change every time the sheet recalculates so you cannot use your formula as a time stamp if that is what you are trying to do.