Hello,
I have a cell that reads a percent (e.g. A1 = 5%).
How can I conditional format the rest of the cells in the column (e.g. A2:A20) to highlight red text if their absolute value is less than A1? Examples of highlighted cells would be 4%, -2%... but not -10%).
I have a cell that reads a percent (e.g. A1 = 5%).
How can I conditional format the rest of the cells in the column (e.g. A2:A20) to highlight red text if their absolute value is less than A1? Examples of highlighted cells would be 4%, -2%... but not -10%).