And formula not working with conditional formatting

Hello. I'm having trouble with this formula. I'm trying to highlight cells in a column if the column says "2018" and if the column next to it says "Prime". It's not working for me.

The formula I used is =AND(C2="2018",D2="Prime")

I also highlighted cells C2:C27 which is the "release" column (column a is hidden)

Did you try using C2=2018 without the quotes?

It looks like your years in column C are proper numbers (aligned to the right), so you do not need to put quotes around 2018 in your CF formula, as this will convert it to a text value. Try it like this:

=AND(C2=2018,D2="Prime")

Hope this helps.

Pete

Another thought is, is the date in Column C actually a year only or is it a full date with the cell only formatted to display the year?

Yeah I tried removing the quotes from each one separately then from both.

Leave the quotes around Prime as it is text. What is actually stored in cell C2? Is it a full date?

That worked. I tried that earlier but it didn't work but when I copied your text to my formula bar it worked. Thanks