I got a strange one here: I have a file that has several formulas, links and conditional formatting in it. I made a copy of that file, saved it with another name and everything works in the file except the conditional formatting. I have simple conditions (if cell = 1, change the fill color to blue, = 2 change fill to red, etc.) and they are no longer working. I even tried to delete and re-do the formatting and they don't work. Any ideas why or how to correct this?
can you post an example spreadsheet
any chance the numbers are actually formatted as text ?
or are you testing as text rather than numbers
"1" = text test
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks