| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I copy conditional formats so it changes cell references?
I want to add some conditional formatting to flag up rows containing less
than a certain number of tick boxes, but when I copy/paste the formula it retains the original cell reference instead of changing it in the way it does when you copy a formula. Help! |
|
#2
|
|||
|
|||
|
How do I copy conditional formats so it changes cell references?
check that the conditional format equation does not have the absolute
reference for cells ($) "Chuckie E." wrote: I want to add some conditional formatting to flag up rows containing less than a certain number of tick boxes, but when I copy/paste the formula it retains the original cell reference instead of changing it in the way it does when you copy a formula. Help! |
|
#3
|
|||
|
|||
|
How do I copy conditional formats so it changes cell reference
Aha...I knew it would be something really simple. Thank you so much!
"bj" wrote: check that the conditional format equation does not have the absolute reference for cells ($) "Chuckie E." wrote: I want to add some conditional formatting to flag up rows containing less than a certain number of tick boxes, but when I copy/paste the formula it retains the original cell reference instead of changing it in the way it does when you copy a formula. Help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
| Syntax for inferred cell references | Excel Worksheet Functions | |||
| How do I find out how many different cell formats an existing wor. | Excel Discussion (Misc queries) | |||
| Unable to Copy COUNTA() with cell references | Excel Worksheet Functions | |||
| copy a cell value not its function | Excel Discussion (Misc queries) | |||
Linear Mode
