| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change colour of cell depending on content
As always a few questions of clarification. 1. do the changes need to take place dynamically or can they take plac by the user running a macro (or in a workbook event eg on save)? 2. are the 14 conditions 14 items that you need to test to determin the colour, or are there 14 different colours that you use fo colouring? The point in the last question is that the three conditions relate t three result positions eg condition 1 colours red, condition 2 colour blue, condition 3 colours yellow. Each can take a complex formula t determine this state. 3. With complex conditions it is worth looking at putting an additiona hidden row or column. then use a formula in that row or column tha returns (say 1,2,3 for red,blue,yellow) then the conditional formattin is easy. In my view much easier to debug -- tony ----------------------------------------------------------------------- tony h's Profile: http://www.excelforum.com/member.php...fo&userid=2107 View this thread: http://www.excelforum.com/showthread.php?threadid=55259 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change colour of cells depending on entry in one cell | Excel Worksheet Functions | |||
| how do i change cell background colour depending on its content? | Excel Discussion (Misc queries) | |||
| Change colour of cell depending on content | Excel Programming | |||
| Changing cell colour depending on content?? | Excel Programming | |||
| Change the colour of a row depending on the contents of a date cell | Excel Programming | |||
![tony h[_134_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
