Conditional Formatting

[Belly]

I would like the conditional formatting to increment the value of the cell by
-1
i.e.
in cell c2 the conditional formatting is:
'Cell Value is' 'equal to' '=$C$2'
in the next cell down I would like it to be:
'Cell Value is' 'equal to' '=$C$3'
and so on down the page, how can I do this?

 

[Dave Peterson]

Don't use
=$c$2

Try:
=$c2

I would like the conditional formatting to increment the value of the cell by
-1
i.e.
in cell c2 the conditional formatting is:
'Cell Value is' 'equal to' '=$C$2'
in the next cell down I would like it to be:
'Cell Value is' 'equal to' '=$C$3'
and so on down the page, how can I do this?