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?
LCCSAMConnect With a Mentor Commented:
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   >>
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.
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.
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?
vmccuneAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.