Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the macro to change background based on numeric cell value
I want that a cell background color will change upon calculating a value.
That is to say, if the calculated value is greater than 1.2, then the background color of that cell will change to red. Conversely, if the calculated value is less than 4.0, then the background color of that cell will change to yellow. The colors which I want to utilize are red, green and yellow. Thank you in advance for your assistance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the macro to change background based on numeric cell value
Hi why do not use a conditional format?
HTH regards from Brazil Marcelo "Still learning" escreveu: I want that a cell background color will change upon calculating a value. That is to say, if the calculated value is greater than 1.2, then the background color of that cell will change to red. Conversely, if the calculated value is less than 4.0, then the background color of that cell will change to yellow. The colors which I want to utilize are red, green and yellow. Thank you in advance for your assistance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the macro to change background based on numeric cell value
Hi,
Go to Format Conditional Formatting... and set your formats for the first case. Then click on the Add button and set the conditions for the next and again for the third case. -- Ken Hudson "Still learning" wrote: I want that a cell background color will change upon calculating a value. That is to say, if the calculated value is greater than 1.2, then the background color of that cell will change to red. Conversely, if the calculated value is less than 4.0, then the background color of that cell will change to yellow. The colors which I want to utilize are red, green and yellow. Thank you in advance for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
Row Expansion | Excel Worksheet Functions | |||
Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Cell Change Color - Need Help | New Users to Excel |