Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Conditional Formating | Excel Discussion (Misc queries) | |||
excel conditional formating decimal fractions | Excel Worksheet Functions | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) |