Apr 25 2021
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 = 0End With
Don't know how I would phrase this in Visual Basic.
May 20 2021