[XL07] Conditionally format fill color for entire row

Oops, I should have seen that myself. My age must be having an effect. Thanks
for your help!

"David Biddulph" wrote:

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

I tried this method, and it formatted the entire selection without regard for
the conditional part. Obviously, I may have erred in the way I did it.

I do have the problem handled via the post from David.

Thanks for your input.

"Spiky" wrote:

On Jul 31, 2:19 pm, Spiky wrote:
Another way is to select all of the cells to be formatted first, then
pick Conditional Format from the menu.

Sorry, didn't finish my own post.

I mean, select them all first, because then Excel should do the
absolute/relative reference properly automatically.