| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
automate the colouring of lots of cells
Use Conditional Formatting. See:
http://www.contextures.com/xlCondFormat01.html -- Gary's Student " wrote: Hi, I wonder if anyone can help me as i don't know where to start! I have a column in an excel spreadsheet which is full of numbers in the format 00:00:00 (HH:MM:SS). There are alot of fields in this column!!! What i have just had to do manually is go through and change the fill colour of the cells if the value is greater than or equal to 00:20:00. If the value of the cell was above 00:30:00 then the cell must be a different colour. Less than 00:20:00 and it should be a another colour. So in total 3 colours. As the column is down to row number '4950' - you can see that this will be a very lengthy process! Is there a way to automate this process? (with a macro?) If there is can anyone point me in the right direction? Thanks Matt! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I drag to extend a series across lots of cells quickly? | Excel Discussion (Misc queries) | |||
| Automate unprotecting of blank cells | Excel Discussion (Misc queries) | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Threaded Mode
