conditional formatting

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

On conditional formatting for dates, say I need dates between 1/1/09-4/30/09
to turn red. Can this be done?
 
condition 1 : formula is :

=AND(A1>=DATE(2009,1,1),A1<=DATE(2009,4,30))
 
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 Formating with IF and AND formula 2
Conditional Formatting 1
Icon set based on another cell 1
Conditional Formats Date Based 1
Conditional Formatting - Dates 2
Date Calculation & Conditional Formatting 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
and and if functions 1

Back
Top