Is there a function that will return the font color used in a cell?
D Don Guillett Aug 24, 2004 #2 Put this in a REGULAR module. Then =fc(a4) if red will give you 3 Function fc(x) fc = x.Font.ColorIndex End Function
Put this in a REGULAR module. Then =fc(a4) if red will give you 3 Function fc(x) fc = x.Font.ColorIndex End Function