| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA-Changing cell color with if then function
I am using office 2000 and tring to write a function in which th
argument is multiplied by 12. If the result is less than 36 I woul like the answer to be highlited in a red cell. If it is greater that o equal to 36 it will remain a white cell. What I have written gives m the numerical answer but does not change the color of the box. This i what I have. Thank you for your help Mike Public Function mult(a As Single) As Single mult = a * 12 If 36 mult Then ActiveCell.Interior.ColorIndex = 3 Else ActiveCell.Interior.ColorIndex = 2 End If End Functio -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the color of a cell based on the color of another cell. | Excel Discussion (Misc queries) | |||
| Changing Cell Color | Excel Discussion (Misc queries) | |||
| Color changing of fonts by using the IF function | Excel Worksheet Functions | |||
| Changing cell color | Excel Programming | |||
| Changing a cell color.... | Excel Programming | |||
Threaded Mode
