Urgent Help Required - Conditional Formatting
Not sure if this is possible... I have applied conditional formatting to a
cell in a row of information, to fill with colour on input of a specific answer from a drop down. Can I make the whole row change to the same colour along with the cell on input of the answer.... can't find out how. Any help much appreciated. thanks |
Urgent Help Required - Conditional Formatting
You can made an entire row respond to a single cell entry with conditional
formatting quite easily. Say you want a format change to all of row 1 when cell A1 has the value 100: -Select the entire row. -In the Conditional Formatting dialog select "Formula is" from the Condition 1 drop down. -Use =$A$1=100 as the formula (the "$" are important) -Enter the desired format. -- Jim "CBD" wrote in message ... | Not sure if this is possible... I have applied conditional formatting to a | cell in a row of information, to fill with colour on input of a specific | answer from a drop down. | | Can I make the whole row change to the same colour along with the cell on | input of the answer.... can't find out how. | | Any help much appreciated. | thanks |
Urgent Help Required - Conditional Formatting
Yes, select all cells. In CF, use a formula (Change Condition 1 to Formula
Is), and lock the column in the formula, such as =$A1TODAY() -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "CBD" wrote in message ... Not sure if this is possible... I have applied conditional formatting to a cell in a row of information, to fill with colour on input of a specific answer from a drop down. Can I make the whole row change to the same colour along with the cell on input of the answer.... can't find out how. Any help much appreciated. thanks |
Urgent Help Required - Conditional Formatting
Thanks so much to you both... perfect !
"Jim Rech" wrote: You can made an entire row respond to a single cell entry with conditional formatting quite easily. Say you want a format change to all of row 1 when cell A1 has the value 100: -Select the entire row. -In the Conditional Formatting dialog select "Formula is" from the Condition 1 drop down. -Use =$A$1=100 as the formula (the "$" are important) -Enter the desired format. -- Jim "CBD" wrote in message ... | Not sure if this is possible... I have applied conditional formatting to a | cell in a row of information, to fill with colour on input of a specific | answer from a drop down. | | Can I make the whole row change to the same colour along with the cell on | input of the answer.... can't find out how. | | Any help much appreciated. | thanks |
All times are GMT +1. The time now is 05:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com