Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to format different range of cells each time
Hi
I'm looking for some help - I am not an expert at Visual Basic. I have an excel holiday chart which i want to use macros to assign when someone has taken a days holiday, sick etc. For each employee the number of days holiday is totalled by a CountIf function. For each time of absence a different colour is assigned. For example, If holiday is taken the cell is coloured red & a number 1 is assigned to each day the employee has taken off. Currently the macro i have tried to assign is either assigning the colour to the full range but not the number 1's. I'm using Excel 2003. Any help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date / time format - and nested formulas selecting from a range | Excel Discussion (Misc queries) | |||
how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
how do you format cells by time? | Excel Discussion (Misc queries) | |||
How to format cells in Excel for time in format mm:ss.00 | Excel Worksheet Functions | |||
subtraction with time format cells | Excel Worksheet Functions |