I have a related problem. In trying to change the color of the entire row
based on the contents of one cell in that row, only the first column gets
changed. The format indicates that it applies to $A$3:$D$22. What have I done
wrong?

Thanks

"M Kan" wrote:

Use a conditional format, Formula Is and tie it to your target cell. Once
you've verified it works, click the format painter then the row.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Trevor Stone" wrote:

Hi All,

Is it possible to conditionally format the fill color for an entire
row based on a cell reference?

For instance,

Columns 1,2,and 3 are text but column 4 is a number. I'd like to fill
the whole row blue if the number in that row equals 100.

Then I think I can use the painter to copy the formatting to the rest
of the sheet.

Any ideas would be great.

Thanks,

Trevor