I need to set up two rules; 1 that will change the fill color on adjacent cells within that row and the other to tally the counts onto another tab for totals.
I have a total 8 columns with a rule set up in column H to change to the appropriate color based on the text entered. How do I get the other cells within that row to change to the same color?
Based on the text in column H, how can I move the counts in my Totals tab? 4 columns in the totals tab; total claims assigned, other, follow up, and completed?