software

I have a formula and have been able to achieve my initial formatting thanks
to everyone's help.

Now I would like to have variations to the formatting that would cover the
following criteria: Let's say that the results of the formula are less than
this month and year.
How could I get that to show up with whatever color I desire? Or, vice versa,
results are greater than current month and year?

How would I achieve this?

That would be conditional formatting with a formula of

=A1lt;=TODAY()-DAY(TODAY())

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Clydequot; gt; wrote in message
...
gt; I have a formula and have been able to achieve my initial formatting
thanks
gt; to everyone's help.
gt;
gt; Now I would like to have variations to the formatting that would cover the
gt; following criteria: Let's say that the results of the formula are less
than
gt; this month and year.
gt; How could I get that to show up with whatever color I desire? Or, vice
versa,
gt; results are greater than current month and year?
gt;
gt; How would I achieve this?