Forum Discussion

Tonya Troxtell's avatar
Tonya Troxtell
Copper Contributor
Feb 05, 2018

Re: Conditional format based on formula results - Marlett font

Thanks! I did not know that was a feature.

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond 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.

Resources