Conditional formating
 

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

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

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


.

Click on say Row5's header, then format, C/F; formulaIs

=IF(COUNTIF($A5:$G5,"X")0,TRUE,FALSE)
pick color, Ok Out

Click again on Row5's Header, then with Format Painter
Select row6's row header and Drag down to say Row Header 50.
Change #'s according to need.

Jim



"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

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


.