Hi,
Thanks for the answer but this still doeas the same as my code.
I need to refer to other sheet in the same workbook and to range of cells (G1:G10) then 1 cell only.


I will have 8 referentials in total while conditional formating allows only 3 for the sheet.


If Cell.Value = Range("G2") Then
Cell.Interior.ColorIndex = 3
End If


and other


If Cell.Value = Range("G2") Then
Cell.Interior.ColorIndex = 3
End If


etc up to 8 or more.


Sorry, forgot to mention!