Conditional Formating
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 |
Conditional Formating
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 |
Conditional Formating
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 |
Conditional Formating
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 |
All times are GMT +1. The time now is 03:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com