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


.