S
samprince
Hopefully these will be quick to answer.
#1 In the set options for conditional formatting there is not option t
Format a cell that is nearest to a value.
atm I have Calculated =Max, =Min, =Average. Ofcourse conditona
formating to show the cell which is the max and the min is simple. I
there a way of showing which cell is the nearest to the Average/Mean?
#2 YOu can drag formula's so that the cell reference change from cel
to cell.
Can you do this with conditional Format option? - atm I have to do eac
column by column to highlight the Min/Max of each as I cannot find/wor
out how to drag. Each time I click the cell which I want to realte t
Excel automatically sets the cell as $x$x as such I cannot move thi
along
#1 In the set options for conditional formatting there is not option t
Format a cell that is nearest to a value.
atm I have Calculated =Max, =Min, =Average. Ofcourse conditona
formating to show the cell which is the max and the min is simple. I
there a way of showing which cell is the nearest to the Average/Mean?
#2 YOu can drag formula's so that the cell reference change from cel
to cell.
Can you do this with conditional Format option? - atm I have to do eac
column by column to highlight the Min/Max of each as I cannot find/wor
out how to drag. Each time I click the cell which I want to realte t
Excel automatically sets the cell as $x$x as such I cannot move thi
along