| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unable to obtain relative reference using conditional formatting
To replicate in Excel 2007:
A1: 2 A2: 1 A3: 3 Select cells A1:A3, with A1 being primary Conditional Formatting New Rule Use a formula to determine which cells to format =A1=MAX(A$1:A1) Format, Bold, OK OK Cells A1 and A3 are bold, as they should be. Select cell A2 Conditional Formatting Manage Rules See that the Rule formula is identical to what was typed in A1; it did not adjust. The same is true with A3, even though they are all working correctly as if they did, in fact, adjust. This is very disconcerting when checking conditional formulae in a very large spreadsheet. Am I doing this correctly? What is going on here? Thank you in advance for your assistance. JP |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unable to obtain relative reference using conditional formatting
This is very disconcerting when checking conditional
formulae in a very large spreadsheet. I couldn't agree more! What is going on here? That's just the way MS did it. Nothing you did was wrong and there's nothing you can do about it. -- Biff Microsoft Excel MVP "JP" wrote in message ... To replicate in Excel 2007: A1: 2 A2: 1 A3: 3 Select cells A1:A3, with A1 being primary Conditional Formatting New Rule Use a formula to determine which cells to format =A1=MAX(A$1:A1) Format, Bold, OK OK Cells A1 and A3 are bold, as they should be. Select cell A2 Conditional Formatting Manage Rules See that the Rule formula is identical to what was typed in A1; it did not adjust. The same is true with A3, even though they are all working correctly as if they did, in fact, adjust. This is very disconcerting when checking conditional formulae in a very large spreadsheet. Am I doing this correctly? What is going on here? Thank you in advance for your assistance. JP |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unable to obtain relative reference using conditional formatti
Thanks, Biff, and best regards,
JP "T. Valko" wrote: This is very disconcerting when checking conditional formulae in a very large spreadsheet. I couldn't agree more! What is going on here? That's just the way MS did it. Nothing you did was wrong and there's nothing you can do about it. -- Biff Microsoft Excel MVP "JP" wrote in message ... To replicate in Excel 2007: A1: 2 A2: 1 A3: 3 Select cells A1:A3, with A1 being primary Conditional Formatting New Rule Use a formula to determine which cells to format =A1=MAX(A$1:A1) Format, Bold, OK OK Cells A1 and A3 are bold, as they should be. Select cell A2 Conditional Formatting Manage Rules See that the Rule formula is identical to what was typed in A1; it did not adjust. The same is true with A3, even though they are all working correctly as if they did, in fact, adjust. This is very disconcerting when checking conditional formulae in a very large spreadsheet. Am I doing this correctly? What is going on here? Thank you in advance for your assistance. JP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set conditional formatting relative to another cell -XL20 | Excel Discussion (Misc queries) | |||
| Unable to copy Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting changing relative when copied to other cell | Excel Worksheet Functions | |||
| XL2K - Conditional Formatting relative to cell selection | Excel Discussion (Misc queries) | |||
| Conditional Formatting, reference another column | Excel Worksheet Functions | |||
Linear Mode
