Hi,

I am pulling out my hair on this one. I have a spreadsheet that is
conditionally formated on date producing 3 colours depending on formula. this
works great in one cell however I want the row to change colour if a cell in
that row = condition.

eg Cell A1 is conditionally date formated, information is in cells A2-A10 .
If A10 is "Yes" cell A1-A10 will turn grey.

Is this possible??
--
You have to throw a stone to make the pond ripple

Hi Haiggy,

on the conditional format selected "the formula is" and put a10="yes"

HTH
Regards from Brazil - going to the 6th *
Marcelo

"Haiggy" escreveu:

Hi,

I am pulling out my hair on this one. I have a spreadsheet that is
conditionally formated on date producing 3 colours depending on formula. this
works great in one cell however I want the row to change colour if a cell in
that row = condition.

eg Cell A1 is conditionally date formated, information is in cells A2-A10 .
If A10 is "Yes" cell A1-A10 will turn grey.

Is this possible??
--
You have to throw a stone to make the pond ripple

Sweet , thanks man hope Brazil go on to win but watch the Argies they look hot.
--
You have to throw a stone to make the pond ripple


"Marcelo" wrote:

Hi Haiggy,

on the conditional format selected "the formula is" and put a10="yes"

HTH
Regards from Brazil - going to the 6th *
Marcelo

"Haiggy" escreveu:

Hi,

I am pulling out my hair on this one. I have a spreadsheet that is
conditionally formated on date producing 3 colours depending on formula. this
works great in one cell however I want the row to change colour if a cell in
that row = condition.

eg Cell A1 is conditionally date formated, information is in cells A2-A10 .
If A10 is "Yes" cell A1-A10 will turn grey.

Is this possible??
--
You have to throw a stone to make the pond ripple

thanks for the feedback.
;)

"Haiggy" escreveu:

Sweet , thanks man hope Brazil go on to win but watch the Argies they look hot.
--
You have to throw a stone to make the pond ripple


"Marcelo" wrote:

Hi Haiggy,

on the conditional format selected "the formula is" and put a10="yes"

HTH
Regards from Brazil - going to the 6th *
Marcelo

"Haiggy" escreveu:

Hi,

I am pulling out my hair on this one. I have a spreadsheet that is
conditionally formated on date producing 3 colours depending on formula. this
works great in one cell however I want the row to change colour if a cell in
that row = condition.

eg Cell A1 is conditionally date formated, information is in cells A2-A10 .
If A10 is "Yes" cell A1-A10 will turn grey.

Is this possible??
--
You have to throw a stone to make the pond ripple