ExcelBanter - Testing for Cell Fill Color

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Testing for Cell Fill Color (https://www.excelbanter.com/excel-worksheet-functions/64927-testing-cell-fill-color.html)

Jim Pockmire

Testing for Cell Fill Color

Is it possible to test for a cell fill color using the "IF" function, much
like testing for the value of a cell (essentially with fill color versus no
fill color)?

Bob Phillips

Testing for Cell Fill Color

See http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

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

"Jim Pockmire" wrote in message
...
Is it possible to test for a cell fill color using the "IF" function, much
like testing for the value of a cell (essentially with fill color versus
no
fill color)?

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