Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Reference confusion
I am trying to apply a conditional formatting rule that would return a true
if the cell immediately to the left does not have a value exactly 1 less than the value of "this cell." My problem is that I can't find a function or reference operator for "this cell" when applied to an entire column. ie- A B C 1 2 5 6 True 3 12 13 True 4 6 5 False 5 7 9 False Conditional formatting applied to column B. I looked at offset, but I need an absolute cell reference to offset from, and I don't have that. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular reference confusion | Excel Discussion (Misc queries) | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
Autofill/Reference Confusion | Excel Worksheet Functions | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |