I have a basic excel sheet that has 1's and 0's with totals in last column and last row. I need to change all the 1's to Q/L and format those cells to yellow. I have been trying to write the vba code for this, but have not been successful. Every time I get close, I am changing every cell that has a 1, which includes the dates and totals.
Would very much appreciate help with this anyone has time.
tks
see attached