Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding sums in rows and columns and colouring cells with condition
Hi all,
I have a long table where i need to add and colour individual cells based on 'days home' and 'days away'. The table is uploaded here https://www.yousendit.com/download/M...UzhoMlYzZUE9PQ In order to automate some of this i'd like to automate some, but preferably all aspects of this, such as: 1. automatically colour the cell orange for "home" and yellow for "away" 2. add separately in the home and away columns the number of days for each 3. add the rows for the alternate lines (ie days only, rates only) I want to do this without yet another row so i thought that if i could add an "a" and an "h" after the number of days in the cell i could set up a conditional format and a sumif, but i simply could not get this to work!! Is there another way...? I hope my problem is clear and would appreciate pointers to move ahead - and i hope it can be achieved simply in excel without getting into complicated vba etc as i am not a professional. thanks in advance. best manosh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding up Cells Given a Condition | Excel Worksheet Functions | |||
adding more columns/rows | Excel Discussion (Misc queries) | |||
How do I turn 1 cell into 2 cells without adding columns or rows? | Excel Discussion (Misc queries) | |||
Adding sums only in certain colored cells | Excel Worksheet Functions | |||
Adding cells based on condition | Excel Worksheet Functions |