Conditional Formatting
 

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?

Conditional Formatting
 

Don't use
=$c$2

Try:
=$c2



Belly wrote:

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