| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
When I select a range of cells for conditional formatting it changes the Cell Refrences. For example. I want a range of cells to have the same conditional formatting like =A1=0 but it changes the next cell to =B1=0 and the next to =C1=0. What do I do? Excel 2002, SP3 -- gregory.barrett ------------------------------------------------------------------------ gregory.barrett's Profile: http://www.excelforum.com/member.php...o&userid=32421 View this thread: http://www.excelforum.com/showthread...hreadid=528219 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting
If it works the same as generally copying references, one method you can use
is the "$" anchor. Whatever parameter that you wish to remain constant, place a dollar sign in front of. For example, if you want to keep the column reference the same, write it as $A1. If you want to keep the row reference the same, write it as A$1. For both, write $A$1. Hope I've helped. "gregory.barrett" wrote: When I select a range of cells for conditional formatting it changes the Cell Refrences. For example. I want a range of cells to have the same conditional formatting like =A1=0 but it changes the next cell to =B1=0 and the next to =C1=0. What do I do? Excel 2002, SP3 -- gregory.barrett ------------------------------------------------------------------------ gregory.barrett's Profile: http://www.excelforum.com/member.php...o&userid=32421 View this thread: http://www.excelforum.com/showthread...hreadid=528219 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting
make it so the formula is $A$1=0 that will make column A1 the constant and
wont change -- --Chip Smith-- MVP Wannabe :) "gregory.barrett" wrote: When I select a range of cells for conditional formatting it changes the Cell Refrences. For example. I want a range of cells to have the same conditional formatting like =A1=0 but it changes the next cell to =B1=0 and the next to =C1=0. What do I do? Excel 2002, SP3 -- gregory.barrett ------------------------------------------------------------------------ gregory.barrett's Profile: http://www.excelforum.com/member.php...o&userid=32421 View this thread: http://www.excelforum.com/showthread...hreadid=528219 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting
that was definately it. Thanks, I never knew that the dollar signs were anchors -- gregory.barrett ------------------------------------------------------------------------ gregory.barrett's Profile: http://www.excelforum.com/member.php...o&userid=32421 View this thread: http://www.excelforum.com/showthread...hreadid=528219 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
| Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
