| 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. |
| 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 | |||
Threaded Mode
