| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Conditional Format by formula containing cell defined name
After creating the names as suggested by .... in your other post, use the
following in conditional formatting formula =INDIRECT("Cost"&ROW())<600 in row 2 and paste the format down "Carr" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Conditional Format by formula containing cell defined nam
Awesome, it worked perfectly.
Many, many thanks Chris "Sheeloo" wrote: After creating the names as suggested by .... in your other post, use the following in conditional formatting formula =INDIRECT("Cost"&ROW())<600 in row 2 and paste the format down "Carr" wrote: 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? |
| Reply |
| 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 | |||
Linear Mode
