Excel Formula Rounding Based on Cell Color
I need to sum all cells in a row, but if the cell has a fill color (based on conditional formatting) AND the number in the cell is either 5 or 6, round that number down to 4.
I need to sum all cells in a row, but if the cell has a fill color (based on conditional formatting) AND the number in the cell is either 5 or 6, round that number down to 4.