E
EG
i am trying to have a row of cells be a certain color if one particular cell
is >0, for example. is there a way to do that?
thanks!
eric
is >0, for example. is there a way to do that?
thanks!
eric
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kassie
Click on Format, Conditional Formatting, change Cell Value to Formula is and
insert this, but change the cell reference to the one you want it to react
to.
=$B$1>0
insert this, but change the cell reference to the one you want it to react
to.
=$B$1>0
J
JLatham
Select the row and then use conditional format and choose the Formula Is
option rather than the Value is
Enter a formula similar to this (assumes that you want to base color on
value in A1)
=$A$1>0
and set up your formatting.
option rather than the Value is
Enter a formula similar to this (assumes that you want to base color on
value in A1)
=$A$1>0
and set up your formatting.
E
EG
thank you! that works fine! one more question, is there an easy way i can
apply that same criteria to following rows but using a different cell? In my
first row, i formatted the cells in the row based on the value in cell M12
being < or > 0. Now i want to format the next row based on the value in cell
M13 being < or > 0. Do i have to type the formulas in for each row each time
or is there an easy way to do each row based on the first row i formatted?
thanks again!
eric
apply that same criteria to following rows but using a different cell? In my
first row, i formatted the cells in the row based on the value in cell M12
being < or > 0. Now i want to format the next row based on the value in cell
M13 being < or > 0. Do i have to type the formulas in for each row each time
or is there an easy way to do each row based on the first row i formatted?
thanks again!
eric
J
JLatham
Select all of the rows that you want to format that way, then do the same
thing with Conditional Format | Formula is, and try this:
=$M12>0
that will keep the column M reference from changing, but in each row you
format that way, the 12 value will be increased by some number. That number
being an adjustment based on the row being formatted.
To try to put it simpler, if you selected rows 20-22 for this, then row 20
cells would show up as formatted "=$M12>0"
row 21 cells should look like "=$M13>0"
and row 22's cells should look like "=$M14>0"
All done by just typing the formula in one time.
thing with Conditional Format | Formula is, and try this:
=$M12>0
that will keep the column M reference from changing, but in each row you
format that way, the 12 value will be increased by some number. That number
being an adjustment based on the row being formatted.
To try to put it simpler, if you selected rows 20-22 for this, then row 20
cells would show up as formatted "=$M12>0"
row 21 cells should look like "=$M13>0"
and row 22's cells should look like "=$M14>0"
All done by just typing the formula in one time.
E
EG
GREAT! tHANKS!
JLatham said:Select all of the rows that you want to format that way, then do the same
thing with Conditional Format | Formula is, and try this:
=$M12>0
that will keep the column M reference from changing, but in each row you
format that way, the 12 value will be increased by some number. That number
being an adjustment based on the row being formatted.
To try to put it simpler, if you selected rows 20-22 for this, then row 20
cells would show up as formatted "=$M12>0"
row 21 cells should look like "=$M13>0"
and row 22's cells should look like "=$M14>0"
All done by just typing the formula in one time.