Solved Multiple formulas for conditional formatting

February 26, 2013 at 07:14:21
Specs: Windows XP
I have an excel spreadsheet tracking software development end dates. I am using an IF statement for conditional formatting to use red/green icons if the end date is earlier than today's date, i.e. =IF(E44>=TODAY(),1,0)
I have another column that tracks % complete. I would like to know if I can add to my above formula so that if the % complete is 100, it will change to green icon (for those that are currently red because the end date is earlier than today's date).
Thanks,

See More: Multiple formulas for conditional formatting

Report •

#1
February 26, 2013 at 13:15:04
✔ Best Answer
Not completely sure how your working this,
but for Conditional Formatting to work,
you only need your formula to return TRUE.

So,since you need two conditions to return TRUE
an AND() function would seem to be in order.

So something like:

=IF(AND(E44>=TODAY(),A1=100%),1,0)

you can make it even shorter with

=AND(E44>=TODAY(),A1=100%)

MIKE

http://www.skeptic.com/


Report •

#2
March 5, 2013 at 12:59:46
I used the 1st example. It works.
Thanks!
PR

Report •
Related Solutions


Ask Question