Hello everyone,

I'm working in MS Excel 2010. I have a spreadsheet with a number cells with conditional formatting applied, some with IF statements.

One cell has a nested IF statement, three functions. The formula works properly, but the conditional formatting won't apply. When I remove the nested IF statement and just manually put in the values, the conditional formatting works as desired. It's only when I have the nested IF statement that the conditional formatting does not work, but both work independently from each other.

The conditional formatting works on the cells with a single IF statement.

Any suggestions? It's not a critical issue on this project, but I'm just determined to make it work.

Thank you for any help,

Bill