Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 . |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help using Conditional Formating of Entire Rows | Excel Worksheet Functions | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Conditional Formating when result is text | Excel Worksheet Functions | |||
30 Day Aging Report Using Conditional Formating | Excel Worksheet Functions |