Conditional Formating Not working for all Rules, it was working but has stoped

Can you tell me what is the problem?

Based on what? It was working; now it's not?

Something has changed.


Regards, TMS

Glad to know you've fixed it.

If you need someone to assess a problem for you, it's usually best to provide a sample workbook that demonstrates the problem. Otherwise there are very few clues.

To attach a sample workbook: Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

You're welcome. Thanks for the rep.

Not sure I did anything to deserve it but always welcome.

Regards, TMS