Conditional formatting using AND on a range

Question

I have a fixed cell $I$1 containing the current date. I have col D whose cells each contain a date. I also have col F which contains a percentage (there is one of these wherever corresponding col D cell has a date).

The conditional formatting I want is: If date in col D is before date in $I$1 AND percentage in corresponding cell of col F is greater than 0, then set format.

Based on previous answers on this site, I've tried the "=AND(AND(...;...);...)" method as well as the "multiplication method". Any hints from an expert (since I'm, obviously, not one!)?

John Bustos · Accepted Answer · 2012-12-12 15:41:57Z

3

This should do it - For example, supposing you wanted to do this formatting for a cell in row 1:

=And($D1 < $I$1, $F1 > 0)

answered Dec 12, 2012 at 15:41

John Bustos

19.7k18 gold badges102 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dave Over a year ago

yes, this worked. I'm so embarrased I didn't figure this out for myself! Thanks again for the help!

martin · Accepted Answer · 2012-12-12 15:46:20Z

2

I have tried it along the lines you suggest and it seems to work OK:

=AND(D1<$I$1;E1>0)

Is this what you want?

enter image description here

answered Dec 12, 2012 at 15:46

martin

2,68024 silver badges29 bronze badges

1 Comment

Dave Over a year ago

yes, that worked great. I'm so embarrased I didn't figure this out for myself! Thanks again for the help!

Collectives™ on Stack Overflow

Conditional formatting using AND on a range

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related