Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cond. Format & Absolute Cell Reference Question
Can I put the first part of a conditional format in an external cell, and
make reference to it, but have reference go to one "Absolute" Cell? The first part of the equation is a IF true, then not, idea. Was / am using: =IF(OR(O9="",E9="d",E9="n",E9="na",H9="pv",RIGHT(J 9,2)="du",RIGHT(M9,2)="du",AI9<$AI$4),"T","") =IF(AU9="T","",.... in conditional format Can I have the info in the 1st part referenced to a single cell, and all other lines refer to it? i.e. line #'s "9" won't be same from every line of the new origin. (Need to make the 9 universal). Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
Problem with formulas changing cell reference | Excel Discussion (Misc queries) | |||
Is there a forumla to link an absolute cell reference in multiple. | Excel Worksheet Functions | |||
Cell Reference Math | Excel Worksheet Functions |