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> </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?