Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is function vs. formula? | New Users to Excel | |||
Need Formula or Function to calculate Margin (reverse of Percent a | Excel Worksheet Functions | |||
How do I create formula to change cell color | Excel Worksheet Functions | |||
Formula for date function | Excel Worksheet Functions | |||
What function or formula do I use to calculate ROI with this data? | Excel Worksheet Functions |