Conditional formating

E

Esrei

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
 
B

Bob Phillips

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)
 
E

ESREI

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.
 
J

Jim May

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
 
B

Bob Phillips

okay, use a formula of

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

--

HTH

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