• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I have strange Excel problem

M

Mariya

New Member
Hi guys,

My problem is the following: I create a file and gather information from different web sites. Where the information is not available I put NA. It happened some of the cells I put NA somehow became pink and I cannot manage it normal with formatting. I guess I have pressed something but I cannot find the reason. The interesting thing is not all NA are like this. Do you have an idea what has happened?
Here is how it looks like:

upload_2018-9-6_22-47-12.png

Thank you!

Mariya
 
Check conditional formatting. When conditions are met, it will override normal formatting applied.
 
Mariya said:
Hi guys,

My problem is the following: I create a file and gather information from different web sites. Where the information is not available I put NA. It happened some of the cells I put NA somehow became pink and I cannot manage it normal with formatting. I guess I have pressed something but I cannot find the reason. The interesting thing is not all NA are like this. Do you have an idea what has happened?
Here is how it looks like:

View attachment 55021

Thank you!

Mariya
Click to expand...
Yes clear the conditional formatting. You can go to Conditional Formatting and click Clear Rules.
 
Thank you guys, I didnt have time to respond at the moment but it was really the the conditional formatting.
Thank you!!!

Mariya
 
You must log in or register to reply here.
Back
Top