C
Carr
I am trying to use conditional format to colour a cell based on a cell on a
different worksheet. I have been able to get it to work but the problem now
is that I need to extend the formatting to the remaining 699 cells based on
699 other defined cells. When I copy the formatting, the formula still
refers to my original defined cell (ie. =not(cost2>600) where "cost2" is
'sheet1'd2).
Is there a way to automatically change the reference in the formula to
cost3, cost4, etc when I copy it?
different worksheet. I have been able to get it to work but the problem now
is that I need to extend the formatting to the remaining 699 cells based on
699 other defined cells. When I copy the formatting, the formula still
refers to my original defined cell (ie. =not(cost2>600) where "cost2" is
'sheet1'd2).
Is there a way to automatically change the reference in the formula to
cost3, cost4, etc when I copy it?