G Guest Aug 31, 2007 #1 in excel, can I use values based on color for an "if, then" condition? if the name is in red font, then multiply B3 by D3.
in excel, can I use values based on color for an "if, then" condition? if the name is in red font, then multiply B3 by D3.
B Bob Phillips Aug 31, 2007 #2 You need a UDF, for example Function CI(rng as Range) If rng.Count = 1 Then CI = rng.Font.Colorindex End If End Sub and use like this =IF(CI(B3)=3,B3*D3,"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
You need a UDF, for example Function CI(rng as Range) If rng.Count = 1 Then CI = rng.Font.Colorindex End If End Sub and use like this =IF(CI(B3)=3,B3*D3,"") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
