Hello again, I was impressed how people quickly reacted and helped me to solve a problem with excel previously for FREE.

One more question I have:

I have dates in column A and words in column B

I want that all dates in column A would be red for example if in column B there is a word "YES", if there is word "NO" then do not format that cell. Now I think I need to choose "Use a formula to determine which cells to format". But have no idea what formula should I use, something with IF I guess.

Also maybe You can give me references to some good learning material about excel so I could not bother You here anymore.

Thank You in advance!