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,

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

I used the 1st example. It works.

Thanks!

PR

Ask Your Question

Weekly Poll