How do I vary the conditional formatting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

=A1<=TODAY()-DAY(TODAY())

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting based on 2 criteria 4
Conditional formatting dates 3
Conditional formatting 1
Conditional Formatting for 6 month intervals (ignoring day and year)?? 0
conditional formatting? 1
Conditional formatting comparing times 12
Possible Conditional Formatting 1
Excel Conditioning Formatting 3

Back
Top