You haven't addressed the point I raised regarding relative or absolute
addressing. If you stick to relative addressing it won't work. You need to
make the row or column reference absolute, as appropriate.
--
David Biddulph

"Rod" wrote in message
...
Yes, I meant B1:h1 was to be highlighted, but at any rate the problem is
the
same. I select a range of cells (be it a row or a column) and then
conditionally format them to be highlighted based upon the value of
another
cell, in this case if A1=100. I go through the routine steps of selecting
the
desired cells, got t CF, select formula, add =A1=100, then select the
desired
formatting.

When I plug 100 into cell A1, only the first cell of the range of cells to
format changes to the desired highlighting. I have retried this with
different cells using new spreadsheets with the same results. When I go
back
and look at the formula, it has the correct range of sells indicated. They
simply don't highlight.

"David Biddulph" wrote:

B1:B5 is part of a column, not a row
To get more than one cell to be affected by one condition in CF, you ned
to
make sure that you've got an appropriate combination of absolute and
relative addressing, hence try =A$1="100"
Are sure that you are looking for a text string of 100? If you are
looking
for a number, get rid of the quote marks.
--
David Biddulph

"Rod" wrote in message
...
I'm having a weird problem. I'm simply trying to do a conditional
format
on a
row, for example: If the value of cell A1 is 100, then highlight cells
B1:B5
with yellow.

I go through to motion of selection B1 through B5, select conditional
formatting, enter formula as =A1="100" then select highlight color
yellow.
The format says "Applies to =$B$1:$B$5", but when the value of A1 is
100
it
only highlights ONE CELL, not all of the celss that it is supposed to
apply
to. It seems to highlight only the first cell and not the rest.

I have opened a new file and done just this one task and it continues
to
do
the same thing.

am I missing something stupid? I've been up for 20 hours.

Thanks