Forum Discussion
formula using format of a cell for if() condition
I would like to use a formula in cell E1 that checks if A1 is filled yellow (or highlighted yellow (255,255,0)). if it is yellow, I want E1 to = B1, if not leave blank.
Hello
I slapped this togehere just to give you an idea.
Use a User Defined function and so something like
Sub IfYellow()
If Selection.Interior.Color = 65535 Then
Selection.Value = Range("B" & Selection.Row).Value
End Sub
This is not tested to have the results you want, but its maybe a start.
Georgie
I slapped this togehere just to give you an idea.
Use a User Defined function and so something like
Sub IfYellow()
If Selection.Interior.Color = 65535 Then
Selection.Value = Range("B" & Selection.Row).Value
End Sub
This is not tested to have the results you want, but its maybe a start.
Georgie