Forum Discussion
Arnold Schwartz
Nov 26, 2017Copper Contributor
Conditional Formatting to Distinguish Between Labels and Numbers
This is my first post and first day of membership in this community. I have a data set, where the cells contain either labels (text), numbers, and blank cells. I want to conditionally format each cel...
Arnold Schwartz
Nov 27, 2017Copper Contributor
OK. I solved this. I applied a conditional formatting formula
"=istext(cell reference)" to the active cell in the data set, and
supplied a color format. Then I copied the format from the active cell
to the rest of the data set. Then, I applied the "isnumber(cell
reference)" to the same active cell, and supplied a different color fill
to that cell; then, similarly, I copied that cell format to the rest of
the data set as well. So, I had two different rules, and this worked. I
noticed that the cell reference when I started was a relative reference,
and I ended up with fully absolute references once the formula and
conditional formatting was completed ... I'm still working on figuring
that out ... but, as I say, it all works now.