Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing colours by conditions
This has probably been asked a hundred times over but hey... i want to change the colour of an area based on the contents of one cell 2 areas, 2 conditions 2 alternating colours anybody know what expression would i need to use to acheive this??? thanks duncan -- duncan79 ------------------------------------------------------------------------ duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833 View this thread: http://www.excelforum.com/showthread...hreadid=542858 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing colours by conditions
You need to use conditional formatting. Select FormatConditional Fomratting
and then follow the prompts. HTH Ian "duncan79" wrote: This has probably been asked a hundred times over but hey... i want to change the colour of an area based on the contents of one cell 2 areas, 2 conditions 2 alternating colours anybody know what expression would i need to use to acheive this??? thanks duncan -- duncan79 ------------------------------------------------------------------------ duncan79's Profile: http://www.excelforum.com/member.php...o&userid=30833 View this thread: http://www.excelforum.com/showthread...hreadid=542858 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing colours by conditions
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 |
#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 |
Reply |
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 |