| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change cell colour
I want to change the colour of individual cells according to certain criteria.
Conditional formatting is ideal but it will only allow me 3 conditions - I need 16! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change cell colour
On Mar 22, 11:26 am, Min wrote:
I want to change the colour of individual cells according to certain criteria. Conditional formatting is ideal but it will only allow me 3 conditions - I need 16! Sounds like you're going to need some VBA for this ... specifically, some kind of 'Select Case' coding ... Check over in .programming forum! ray |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change cell colour
this might help
http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Min" wrote: I want to change the colour of individual cells according to certain criteria. Conditional formatting is ideal but it will only allow me 3 conditions - I need 16! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change cell colour
this is very helpful - thank you!
"John" wrote: this might help http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Min" wrote: I want to change the colour of individual cells according to certain criteria. Conditional formatting is ideal but it will only allow me 3 conditions - I need 16! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Cell colour | Excel Discussion (Misc queries) | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| Change cell colour | Excel Worksheet Functions | |||
| cell colour change | Excel Worksheet Functions | |||
| COLOUR CHANGE IS A CELL | Excel Discussion (Misc queries) | |||
Linear Mode
