Forum Discussion
Tonya Troxtell
Feb 05, 2018Copper Contributor
Re: Conditional format based on formula results - Marlett font
Thanks! I did not know that was a feature.
1 Reply
- SergeiBaklanDiamond Contributor
It works but with some tricks if you'd like to compare column-to-column. Icons sets works directly only with absolute reference, the workaround is to use OFFSET like
=OFFSET($D$3,ROW()-ROW($D$3),0)
for that data
apply it only to first cell
and when Format Painter on entire column.