How to create a formula for this function.
 

Hi,
How to create a formula for this function please?
If the value in cell X is smaller than 25 then cell Y shall be in a certain
shade of grey but if
the value in cell X is bigger than 25 but smaller than 50 then cell Y shall
be in a darher shade of grey but if
the value in cell X is bigger than 50 but smaller than 75 then cell Y shall
be in a darker shade of grey
and so on. Hope you be able understand what I need. Many thanks.
Best regards

Hi

With conditional formatting you can have 3 conditions with according
shadings + default shading (when none of conditions is true). When you want
more, then you have to write VBA code which shades cells (worksheets Change
event, or Open event, or a procedure triggered manually - on your choice).


--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"How to create a forrmula" <How to create a
wrote in message
...
Hi,
How to create a formula for this function please?
If the value in cell X is smaller than 25 then cell Y shall be in a
certain
shade of grey but if
the value in cell X is bigger than 25 but smaller than 50 then cell Y
shall
be in a darher shade of grey but if
the value in cell X is bigger than 50 but smaller than 75 then cell Y
shall
be in a darker shade of grey
and so on. Hope you be able understand what I need. Many thanks.
Best regards