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, JP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to obtain relative reference using conditional formatting | Excel Worksheet Functions | |||
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) |