Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to write a function to colour a given cell based on the value of a
variables. Below if what I have so far. But I am not sure how to define the function or how to use cells in functions. Any assistance is appreciated. If wsResults.Cells(x, y).Value < (z) Then Cells(x,y).Select With Selection.Interior .ColorIndex = 37 .Pattern = xlSolid End With ElseIf wsResults.Cells(x,y).Value (z) Then Cells(x,y).Select With Selection.Interior .ColorIndex = 36 .Pattern = xlSolid End With End If |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing all cells in one colour to a different colour | Excel Discussion (Misc queries) | |||
use "countif" function to count cells by colour | Excel Worksheet Functions | |||
i want to use the =if function to apply a colour to other cells | Excel Worksheet Functions | |||
Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) | |||
How can I change the colour of cells using an IF function? | Excel Worksheet Functions |