Conditional formatting rules using a formula AND an icon set

olivermuk 

Hi Olly,

You may work with formulas and the icons set, the only issue formulas here work only with absolute references. As workaround you may use OFFSET, INDIRECT or INDEX to have the proper references. For such sample

first formula is

=INDIRECT("A"&ROW())*1.2

second one is similar.

Another trick, you can't apply such rule to entire range at once. Thus first apply to B1 (for our sample) and that move formatting by Format Painter on other cells.