Conditional Format Formula

  • Thread starter Thread starter Jay Gustafson
  • Start date Start date
J

Jay Gustafson

Hello,

I have tried my best to take a formula I have previous used and alter it into a formula so that it will work with my new problem, but I'm having no luck getting this to do what I want it to do.

This is the formula I have in place...

=($AC3>=$B$1)*($AC3<=$C$1)

I have a spreadsheet with many records. One column contains due dates. The due dates are in column AC.

What I would like is if due date column is 'equal to or greater than cell B1 and equal to or less than cell C1 then color entire row with red.

What I basically want, is the ability to put in two dates. And anything that falls on those dates specifically, or between them, I want the row to change color so I can easily spot them in the list.

I'd appreciate any help greatly.

Thank you,
Jay
 
Jay,

Try this:

=AND(AC3>=B1,AC3<=C1)

Biff
-----Original Message-----
Hello,

I have tried my best to take a formula I have previous
Click to expand...
used and alter it into a formula so that it will work with
my new problem, but I'm having no luck getting this to do
what I want it to do.
This is the formula I have in place...

=($AC3>=$B$1)*($AC3<=$C$1)

I have a spreadsheet with many records. One column
Click to expand...
contains due dates. The due dates are in column AC.
What I would like is if due date column is 'equal to or
Click to expand...
greater than cell B1 and equal to or less than cell C1
then color entire row with red.
What I basically want, is the ability to put in two
Click to expand...
dates. And anything that falls on those dates
specifically, or between them, I want the row to change
color so I can easily spot them in the list.
 
Back
Top