General discussion


excel question

By hilalpaksoy ·
hi everyone
i am sure it s easy but i dont know how to do it.

i am making 7 tables (excel sheets) for 7 groups working in the building to see the times people are having off sick,holiday,overtime...etc.

the question is i want to make another main sheet to see everything on that and when i make a change in one of the 7 sheets i want it to be done in the main sheet automatically.i can use formulas and things but ie. i paint the cells to grey to show people`s that grey can also be shown in the main sheet in the right place?? is there any formula for that???

thanks in advance.............

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

conditional formatting

by 1231 In reply to excel question

I'm not exactly sure HOW you are doing it, but look at conditional formatting. You can construct test such as if(a5>1,true,false) and set the attributes of the cell to be white on false (in attendance) or grey on true (on vacation).

I'd also suggest using named areas for each employee's schedule. It's a pain to set up, but easier to maintain.

Related Discussions

Related Forums