How to create a formula for this function.

  • Thread starter How to create a forrmula
  • Start date
H

How to create a forrmula

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
 
A

Arvi Laanemets

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<at>tarkon.ee
Arvi Laanemets


"How to create a forrmula" <How to create a
[email protected]> wrote in message
news:[email protected]...
 
Top