You need to understand the difference between relative and absolute
addressing.
Having seen what you've got in your formula for formatting A3, have a look
at what you've got as the formula for cell B4, for example.

If you are trying to apply the format to all columns as a result of the
content of column D, then in your original formula change your =D3="VG" to
=$D3="VG"
--
David Biddulph

"Derf" wrote in message
...
The formula reads as =D3="VG" and it applies to =$A$3:$D$27

Only the "A" column gets formatted.

Did I provide what you needed?

Thanks.

"Peo Sjoblom" wrote:

How does the formula look under formula is ?

--


Regards,


Peo Sjoblom

"Derf" wrote in message
...
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