Excel Color formatting via formula


I was given a spreadsheet that had been damaged was was recovered.  The only issue the user has is the sheet contains formulas to color cells that no long work.

This formula works: =COUNTIF(AM$79:AM$79,"1 RED")

This does not: =IF(AN75>0,"",IF(AL75<$B$1,"1 RED",IF(AL75<$B$1+15,"2 YEL",IF(AL75>$B$1+14,"3 GRN"))))

Since one does and one doesnt, any thoughts?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Have you considered using conditional formatting?
I find it to be more stable than trying to change the colors in the cells formula.
vmccuneAuthor Commented:
This is a large spreadsheet from another dept and I am hoping to get out of it quickly.  Long story short, it worked before.
The first one is using "1 Red" as a criteria so that doesn't affect the color of the cell. I would take a look for pre-existing conditional formatting rules. That may be where your issue lies.

Without seeing the spreadsheet itself I can't see exactly what the formulas are stuck on.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

vmccuneAuthor Commented:
Ok.  I found it with your statement that it was still using conditional formatting.  I assumed 1 Red was Excel VBA for the color red.  Stupid me.  

Do you know offhand if it is possible to import the conditional formatting statements from one spreadsheet to another?
You can copy the cells in the other worksheet and then do a Paste Special...Formats to copy all the formatting (including conditional formats) across from one sheet to another. Or you can similarly use the Paintbrush tool. These tips are discussed in more detail in:


<<I converted the previously "blind" link above into a properly qualified link by adding the italicized text. Experts Exchange has embarked on a program to eliminate blind links to improve answer quality and Google page rank. As part of this effort, comments that contain only blind links are subject to deletion.

byundt--Microsoft Excel Topic Advisor   >>

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vmccuneAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.