Using If in Visual Basic to change cell's Zoom based on text color

Occasional Contributor

I have Excel 2016 on a Windows laptop.

I want to use the If function in Visual Basic to change a cell's zoom based on the text color of that cell.


For example. If the cell has red text, the zoom should be to the selection. If the text color is black the zoom should be at 100%.


Using a macro, the cell's color is shown as a "with" statement. For example, a red text would be                

"With Selection.Font
.Color = -16776961
.TintAndShade = 0
End With


Don't know how I would phrase this in Visual Basic.



Frank Drucker

1 Reply
Well, it's been almost a month with 71 views and no replies. I guess this was just not possible.

I appreciate everyone who looked.

Frank Drucker