software

Hello everybody this is my firs post and I do appreciate you help.

I am trying to set up conditional formatting so that after the 5th of
every month the cell’s text becomes red, regardless of month or year. I
have bean able to set it up for a specific date mm/dd/yy but this
unfortunately does not help in my particular instance. I need to some
how specify to excel that neither the month nor the year are relevant
only the day of the month.

Also is there a way to time stamp the date you made an entry into a
cell? For example I receive a check and input the check amount into the
appropriate cell, I than put the date received in the neighboring cell.
What I am looking for is ways to automate this process by excel
automatically dating the entry for me.--
Alib
------------------------------------------------------------------------
Alib's Profile: www.excelforum.com/member.php...oamp;userid=29980
View this thread: www.excelforum.com/showthread...hreadid=496746
Use this in the CF Formula is Option to color your cell Red if the

=DAY(A12)gt;5

Cheers,Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=496746or maybe it should be

=DAY(TODAY())gt;5

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;SteveGquot; gt; wrote in
message ...
gt;
gt; Use this in the CF Formula is Option to color your cell Red if the
gt;
gt; =DAY(A12)gt;5
gt;
gt; Cheers,
gt;
gt;
gt; Steve
gt;
gt;
gt; --
gt; SteveG
gt; ------------------------------------------------------------------------
gt; SteveG's Profile:
www.excelforum.com/member.php...foamp;userid=7571
gt; View this thread: www.excelforum.com/showthread...hreadid=496746
gt;