Select B1:H1

CFFormula is: =$A1=100

Note the $ sign to fix column A as absolute.


Gord Dibben MS Excel MVP

On Sun, 5 Oct 2008 07:58:03 -0700, Rod
wrote:

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