ExcelBanter - Any IF(A2=font color=red", "1", "0") in excel? Or a way to do it?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Any IF(A2=font color=red", "1", "0") in excel? Or a way to do it? (https://www.excelbanter.com/excel-discussion-misc-queries/54083-any-if-a2%3Dfont-color%3Dred-1-0-excel-way-do.html)

Steve

Any IF(A2=font color=red", "1", "0") in excel? Or a way to do it?

Bob Phillips

Any IF(A2=font color=red", "1", "0") in excel? Or a way to do it?

Function GetColorindex(rng As Range)
GetColindex = rng.Interior.Colorindex
End Function

=If(GetColorindex(A2)=3,1,0)

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Steve" wrote in message
...

All times are GMT +1. The time now is 10:15 PM.