How to apply conditional formatting to each column separately?

Hi John and welcome to the forum,

Select a single column by clicking on the Letter above the column. Then apply CF using the selected column. Click on the next column head and do it again.
If that isn't the answer, we need a sample of what you have to understand the problem better. See the yellow banner above to see how to attach a file.

Try

Please Login or Register  to view this content.

I don't know anything about MAC-based products so I cannot advise on what is required.

Please update your profile to show the Excel version you are using.

Delete Delete

Select all columns and use the following CF:

Formula:

Please Login or Register  to view this content.

Adapt ranges as required but make sure the absolute and relative references are correct !
You will of course have the same formatting everywhere
( depending on your regional settings you have to replace the comma with a semi colon)

Dear Pepe Le Mokko,
I tried in different ways to use your very clear advice but I failed. I tried to insert as function, use the file you attached and copy my data but doesn't work.
I think it's strange that a so simple option is so difficult to obtain on excel. Thank You! Anyway finally I found this solution on techcommunity.microsoft.com (I can't link it):

"‎Mar 19 2020 12:04 PM

How to conditionally format many columns independently
Hi,
I am struggling to find a solution for a problem I encountered. I have a data sheet with many columns and each column represents data from an individual person. In each column, there are words which a person used as a response for a particular instruction."



I didn't understand the formula, I used the file attached and it worked. Right now understanding the formula is not a priority for me.

The formula (in italian version) is:

Formula:

Please Login or Register  to view this content.

Thank you!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.