Conditional Formatting that highlights cells on two conditions

Hello,

I want to create a conditional formatting rule that says:

IF the dates in column K are equal to cell J1 AND has a RAG status of G or C in column R, highlight the date in cell in column K to red.

In my example, this should highlight all cells that have a date of 02 Aug 13 and have a RAG of G or C. The formula should highlight the following cells: K11, K13, K19, K57, K72, K101, K128, K146, K201, K257, K402.

Many thanks in advance.Example workbook v73.xlsm

Doesn't work - getting an error. Have you tried that formula yourself in my workbook..?

Hi
I came up with an identical formula
are you perhaps missing the equals sign?

=AND(K3=$J$1,OR(R3="G",R3="C"))

The formula is now working however for some reason it seems to be highlighting 2 cells above rather than the cell with the date 2nd august?

Thanks

Sorry - still doesn't seem to be working. Please can you put the formula in the workbook and re-upload so I can see where I am going wrong?

Thanks

Apologies all.. I have now sorted this

Thanks all for you're help.