Forum Discussion
Conditional format based on formula results - Marlett font
Good Morning
I am using the following formula and would like to format the results based on the results of the formula.
=IF(C2<'2-1'!B2,"u",IF(C2>'2-1'!B2,"t","v"))
When shown in Marlet...
Alternatively you may use built-in into conditional formatting arrows icons set using formula for rules (and show icons only if desired)
- Thanks! I did not know that was a feature.
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.
