I have a data sheet with values currently in Columns D:AA
<o
> </o
>
Values are regularly added to the first empty column but notalways to every row.
<o
> </o
>
My Column C formula calculates the average of the 4 lowestvalues from the last 8 values in each row.
<o
> </o
>
I’d like to conditionally format the sheet to show whichvalues are used for each row’s calculation. Any ideas on how to accomplish this?
<o
Values are regularly added to the first empty column but notalways to every row.
<o
My Column C formula calculates the average of the 4 lowestvalues from the last 8 values in each row.
<o
I’d like to conditionally format the sheet to show whichvalues are used for each row’s calculation. Any ideas on how to accomplish this?