| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing colours by conditions
At the Conditional Formating prompt select "Formula is" and enter =$H$13=1
or whatever the criteria is. db "duncan79" wrote in message ... Thanks, but... how does this work if the condition the colour relies on is not the cell whose colour is to be changed If the area is K14:P33 and the condition is in H13??? -- duncan79 ------------------------------------------------------------------------ duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833 View this thread: http://www.excelforum.com/showthread...hreadid=542858 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing a cell to changing the link | Excel Worksheet Functions | |||
| Changing Colours With Protection | Excel Discussion (Misc queries) | |||
| Changing colours in chart | Charts and Charting in Excel | |||
| Change the default chart colours | Charts and Charting in Excel | |||
| multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
Threaded Mode
