| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent help required! | Excel Discussion (Misc queries) | |||
| Urgent help required. | Excel Discussion (Misc queries) | |||
| Conditional Formatting help required | Excel Discussion (Misc queries) | |||
| Urgent Help required on printing option | Excel Discussion (Misc queries) | |||
| Conditional formatting help required please | Excel Discussion (Misc queries) | |||
Hybrid Mode
