Use relative references:

=ISEVEN(A1)
=ISODD(A1)

Regards,
Stefi

"vishu" wrote:

Hi,
I am trying to do Conditional formatting for odd and even numbers.
If number is Even, the cell pattern colour should be Red
If number is Odd, the cell pattern colour should be Blue
The formula I given is =ISEVEN($A$1) and in format selected the red colour.
=ISODD($A$1) and in format selected the
blue colour.
This formula is not working€¦.
But I am getting error message that you may not use references to other
worksheets or workbooks for conditional formatting criteria.
Please advice€¦