Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Conditional Format by formula containing cell defined name
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(cost2600) 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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format if cell contains formula | Excel Worksheet Functions | |||
How do copy a conditional format formula downards? | Excel Worksheet Functions | |||
Is it possible to copy a conditional format formula as paste value | Excel Discussion (Misc queries) | |||
Copy Formula Is conditional format | Excel Worksheet Functions | |||
How do I copy a conditional format that uses a formula in a serie. | Setting up and Configuration of Excel |