Conditional formating-format the cell background "Red".

OK
I got it to work by using
=TODAY()>A1+4
The cell now turns 'red' when 4 days have passed, which is exactly what I wanted.

Now the only problem is...
When I copy that conditional formating to another cell, which is 'empty', it gets filled in with 'red'.
Is there a way to stop this from happening?

Thanks again.

You could use an "IF" statement in your conditional formula:

=IF(COUNT(A1)<>0,TODAY()>A1+4,0)

Then if there's something in the cell, it checks the date, otherwise, it
assumes you don't want to conditionally format it.

Michael


"Unplugged" <[email protected]> wrote in
message news:[email protected]...
>
> OK
> I got it to work by using
> =TODAY()>A1+4
> The cell now turns 'red' when 4 days have passed, which is exactly what
> I wanted.
>
> Now the only problem is...
> When I copy that conditional formating to another cell, which is
> 'empty', it gets filled in with 'red'.
> Is there a way to stop this from happening?
>
> Thanks again.
>
>
> --
> Unplugged
> ------------------------------------------------------------------------
> Unplugged's Profile:
> http://www.excelforum.com/member.php...o&userid=36751
> View this thread: http://www.excelforum.com/showthread...hreadid=564685
>

=AND(A1<>"",TODAY()>A1+4)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Unplugged" <[email protected]> wrote in
message news:[email protected]...
>
> OK
> I got it to work by using
> =TODAY()>A1+4
> The cell now turns 'red' when 4 days have passed, which is exactly what
> I wanted.
>
> Now the only problem is...
> When I copy that conditional formating to another cell, which is
> 'empty', it gets filled in with 'red'.
> Is there a way to stop this from happening?
>
> Thanks again.
>
>
> --
> Unplugged
> ------------------------------------------------------------------------
> Unplugged's Profile:
http://www.excelforum.com/member.php...o&userid=36751
> View this thread: http://www.excelforum.com/showthread...hreadid=564685
>

Thanks so much for all your help people.
It now works perfectly!

Really nice to know there are people out there who are so generous with their knowledge and time.

Best wishes, and thanks again.