okay, use a formula of

=COUNTIF(1:1,"x")0

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ESREI" wrote in message
...
it is not only the value in one cell there are losts of
cells in the sheet with value x and I want excel to chang
the coulor of every row where this value apears.
-----Original Message-----
Don't know why you are using indirect, but select the
whole row and use a
formula of

=$A1="x"

oe whatever cell it is

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Esrei" wrote in
message
...
I want to change the background of a whole line in a
worksheet every where where the value of a cell in that
line is X. =indirect("rc",0)= "x" only changes the
background in the cell not the whole line


.