Excel 200 conditional formatting problem

[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

 

[Gord Dibben]

Select the number of rows you want to format.

Excel 2003............Format>Conditional Formatting>Formula is:

=$D1="done"

Format to a nice color.

Excel 2007...........same thing except commands are a little different.

Home tab>Conditional Formatting>New Rule>"use a formula to determine etc."


Gord Dibben MS Excel MVP

 

[kenackr]

Select the number of rows you want to format.

Excel 2003............Format>Conditional Formatting>Formula is:

=$D1="done"

Format to a nice color.

Excel 2007...........same thing except commands are a little different.

Home tab>Conditional Formatting>New Rule>"use a formula to determine etc."


Gord Dibben MS Excel MVP




Gord, Thanks for your reply.

I'm actually using Excel 2000 which is in the title. I have no problem
making the text turn a different color when the text of that individual cell
=done.

What I'm attempting to do is to turn the entire ROW (all cells) to a gray
where in which that individual cell is located and no others.