I need to highlight (with conditional formatting) a range of column headers based on the contents of the long range below.
The range below had content only in occasional cells, all of which are positive numbers (the cells are otherwise empty). These filled cells are conditionally formatted as Red or Green, depending on whether this value is greater or lower than the number in the same line of a reference column (C) (whilst ignoring any empty value): e.g. the formula for the first data cell (line 2) in column L is currently: =IF(L2>0, L2<$C2)
My problem is how to get the column header cell (L1, M1, etc.) to format as e.g. green IF ALL cells with content below are Green, but not in ANY are red.
Is there a way (without resorting to VB which I don't know at all!)
Thanks!!
The range below had content only in occasional cells, all of which are positive numbers (the cells are otherwise empty). These filled cells are conditionally formatted as Red or Green, depending on whether this value is greater or lower than the number in the same line of a reference column (C) (whilst ignoring any empty value): e.g. the formula for the first data cell (line 2) in column L is currently: =IF(L2>0, L2<$C2)
My problem is how to get the column header cell (L1, M1, etc.) to format as e.g. green IF ALL cells with content below are Green, but not in ANY are red.
Is there a way (without resorting to VB which I don't know at all!)
Thanks!!
