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

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$10


--
kassie

never stop learning


"EG" wrote in message
...
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

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$10
and set up your formatting.

"EG" wrote:

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

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

"JLatham" wrote:

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$10
and set up your formatting.

"EG" wrote:

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

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:
=$M120

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 "=$M120"
row 21 cells should look like "=$M130"
and row 22's cells should look like "=$M140"

All done by just typing the formula in one time.

"EG" wrote:

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

"JLatham" wrote:

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$10
and set up your formatting.

"EG" wrote:

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

GREAT! tHANKS!

"JLatham" wrote:

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:
=$M120

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 "=$M120"
row 21 cells should look like "=$M130"
and row 22's cells should look like "=$M140"

All done by just typing the formula in one time.

"EG" wrote:

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

"JLatham" wrote:

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$10
and set up your formatting.

"EG" wrote:

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