colour given number of cells

[delta5555]

hi,
is it possible to colour fill a given amount of cells, eg. if a1 = 5 then the 5 cells below will change colour,
and if the number changes then the amount of highlighted cells changes

thanks

 

[PaddyD]

On 2002-09-23 15:41, delta5555 wrote:

hi,
is it possible to colour fill a given amount of cells, eg. if a1 = 5 then the 5 cells below will change colour,
and if the number changes then the amount of highlighted cells changes

thanks

Yes to both!

colour cell depending on value / condition = conditional formatting.

change value of cell depending on value / condition of another cell = appropriate formula.

Check out conditional formatting in the help & post back with more info on the details of what you are trying to do.

Paddy

 

[delta5555]

im making a daily line bar schedule and i need to highlight cells to show how many people are on shift at any point in time,,

the highlighted cells will be next to peoples names

 

[PaddyD]

On 2002-09-23 16:17, delta5555 wrote:
im making a daily line bar schedule and i need to highlight cells to show how many people are on shift at any point in time,,

the highlighted cells will be next to peoples names

OK - but what are the conditions you want to implement? Please describe your data & the expected outcomes in a little more detial - no mind readers here!

paddy