K
kenackr
I haven't programmed in 20 years and have lost the chops I did have.
I have a small spread sheet that has a specific column range (D$
$) that
needs to be searched for a text code during a SORT to determine which cells
equal the code word "done". Then for each cell with that code, the entire row
that it sits in gets grayed out to make it distinguishable from other cell
entries in column D$ range D$$ that are NOT equal to done.
After 3 sessions of trying to remember how to do this and having read the
helps sections associated with it, I continue to get errors and the formula
does not work.
My last attempt ended with a formula: =If (D$$="done",$6:$17) .
The range shown on the right end is the range of the row numbers to be
grayed out if "done" is found in a column D cell. I DO NOT want the entire
range grayed out - only those rows with cells in column D that ="done".
While I realize that the condition portion of the IF statement (left side
in parens) returns a value of 1 or 0 (true/false) depending on equality to
"done" in each cell, I don't remember if EACH cell address is passed to the
range argument on the right side to be acted upon in the conditional
formatting individually. Apparently not since it doesn't work.
A little help would be kindly appreciated.
Ken
I have a small spread sheet that has a specific column range (D$
$) thatneeds to be searched for a text code during a SORT to determine which cells
equal the code word "done". Then for each cell with that code, the entire row
that it sits in gets grayed out to make it distinguishable from other cell
entries in column D$ range D$
$ that are NOT equal to done.After 3 sessions of trying to remember how to do this and having read the
helps sections associated with it, I continue to get errors and the formula
does not work.
My last attempt ended with a formula: =If (D$
$="done",$6:$17) .The range shown on the right end is the range of the row numbers to be
grayed out if "done" is found in a column D cell. I DO NOT want the entire
range grayed out - only those rows with cells in column D that ="done".
While I realize that the condition portion of the IF statement (left side
in parens) returns a value of 1 or 0 (true/false) depending on equality to
"done" in each cell, I don't remember if EACH cell address is passed to the
range argument on the right side to be acted upon in the conditional
formatting individually. Apparently not since it doesn't work.
A little help would be kindly appreciated.
Ken