Forum Discussion
IF/THEN FORMATTING
Background: I have a column (A) formatted so that it 'fills' a cell with a color based on a numerical range input by me, three ranges used. I have a column (B) that needs a value from columns (C, D, ...
Let's say the ranges used for column A are:
< 50
>= 50 and < 100
>100
In B2:
=IF(A2<50, C2, IF(A2<100, D2, E2))
Fill down.