Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Range
I have selected a range for conditional formatting. It works fine. However,
when I type outside that range, the conditional formatting applies there too. For instance, if I have set up a range of A1:A10 to highlight in yellow and I type a number greater than 100, this condition seems to apply to A11 too. Shouldn't it apply to only the selected range? The condition seems to apply to the next column too. Any information would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Range
Exactly what formula did you use in CF?
When you select a range prior to invoking CF, the CF formula should refer to the cell in focus, and use relative references. For example - click in A1 and drag down to A10 - to select the range A1:A10. You'll see that A1 is white, denoting that A1 is the cell in focus. Your CF formula should have a relative reference to A1: =A1100 Click on <Format and make your choices, then <OK <OK. You should now have *only* A1 to A10 included in your CF. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Jean" wrote in message ... I have selected a range for conditional formatting. It works fine. However, when I type outside that range, the conditional formatting applies there too. For instance, if I have set up a range of A1:A10 to highlight in yellow and I type a number greater than 100, this condition seems to apply to A11 too. Shouldn't it apply to only the selected range? The condition seems to apply to the next column too. Any information would be greatly appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Range
When you select A11 and look at Format/ Conditional Formatting, what do you
see? If you have a condition set there, you can delete it. Did you perhaps originally set up the condition to apply to A1:A10 and then insert a cell within that range, or insert a row? If the formatting seems to be applying in column B, too, then again select the relevant cells and look at Format/ Conditional Formatting. -- David Biddulph "Jean" wrote in message ... I have selected a range for conditional formatting. It works fine. However, when I type outside that range, the conditional formatting applies there too. For instance, if I have set up a range of A1:A10 to highlight in yellow and I type a number greater than 100, this condition seems to apply to A11 too. Shouldn't it apply to only the selected range? The condition seems to apply to the next column too. Any information would be greatly appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Range
No, I just checked and there is no CF in cell A11. However, when I typed a
200 in cell C11, CF was applied. I don't want it to be applied outside of my selected range. Actually, I just did this again on a brand new spreadsheet, and the issue exists there too. This is very curious. "David Biddulph" wrote: When you select A11 and look at Format/ Conditional Formatting, what do you see? If you have a condition set there, you can delete it. Did you perhaps originally set up the condition to apply to A1:A10 and then insert a cell within that range, or insert a row? If the formatting seems to be applying in column B, too, then again select the relevant cells and look at Format/ Conditional Formatting. -- David Biddulph "Jean" wrote in message ... I have selected a range for conditional formatting. It works fine. However, when I type outside that range, the conditional formatting applies there too. For instance, if I have set up a range of A1:A10 to highlight in yellow and I type a number greater than 100, this condition seems to apply to A11 too. Shouldn't it apply to only the selected range? The condition seems to apply to the next column too. Any information would be greatly appreciated. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Range
My CF formula in cells A1:A10 is "Cell Value is Greater than or equal to
100." I just checked and there is no CF in cell A11. However, when I typed a 200 in cell C11, CF was applied. I don't want it to be applied outside of my selected range. Actually, I just did this again on a brand new spreadsheet, and the issue exists there too. This is very curious. "RagDyeR" wrote: Exactly what formula did you use in CF? When you select a range prior to invoking CF, the CF formula should refer to the cell in focus, and use relative references. For example - click in A1 and drag down to A10 - to select the range A1:A10. You'll see that A1 is white, denoting that A1 is the cell in focus. Your CF formula should have a relative reference to A1: =A1100 Click on <Format and make your choices, then <OK <OK. You should now have *only* A1 to A10 included in your CF. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Jean" wrote in message ... I have selected a range for conditional formatting. It works fine. However, when I type outside that range, the conditional formatting applies there too. For instance, if I have set up a range of A1:A10 to highlight in yellow and I type a number greater than 100, this condition seems to apply to A11 too. Shouldn't it apply to only the selected range? The condition seems to apply to the next column too. Any information would be greatly appreciated. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Range
From the menu bar:
<Tools <Options <Edit tab, *UNCHECK* "Extend List Formats & Formulas" This feature will *extend* CF when CF appears in at least 3 of the 5 last rows preceding the new row. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jean" wrote in message ... My CF formula in cells A1:A10 is "Cell Value is Greater than or equal to 100." I just checked and there is no CF in cell A11. However, when I typed a 200 in cell C11, CF was applied. I don't want it to be applied outside of my selected range. Actually, I just did this again on a brand new spreadsheet, and the issue exists there too. This is very curious. "RagDyeR" wrote: Exactly what formula did you use in CF? When you select a range prior to invoking CF, the CF formula should refer to the cell in focus, and use relative references. For example - click in A1 and drag down to A10 - to select the range A1:A10. You'll see that A1 is white, denoting that A1 is the cell in focus. Your CF formula should have a relative reference to A1: =A1100 Click on <Format and make your choices, then <OK <OK. You should now have *only* A1 to A10 included in your CF. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Jean" wrote in message ... I have selected a range for conditional formatting. It works fine. However, when I type outside that range, the conditional formatting applies there too. For instance, if I have set up a range of A1:A10 to highlight in yellow and I type a number greater than 100, this condition seems to apply to A11 too. Shouldn't it apply to only the selected range? The condition seems to apply to the next column too. Any information would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting In a Range | Excel Discussion (Misc queries) | |||
Conditional formatting - range of dates | Excel Discussion (Misc queries) | |||
Conditional Formatting for a Range | Excel Discussion (Misc queries) | |||
Conditional Formatting for a range situation | Excel Worksheet Functions | |||
HOW TO USE CONDITIONAL FORMATTING FROM ONE RANGE TO ANOTHER RANGE | Excel Worksheet Functions |