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.

  1. 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?

  2. 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?

    enter image description here

enter image description here

  • Can you give a sample of data? A screenshot of dummy data, perhaps? – Vylix Jun 5 '17 at 3:41
  • @Vylix - Please see edit – Tquiroz Jun 5 '17 at 4:24
  • What is the expected result? What "counts" ? Activity counts? Folder moved to counts? – Vylix Jun 5 '17 at 4:27
  • It will be based off of the counts in Folder moved. – Tquiroz Jun 5 '17 at 4:28
  • I mean, where the count formula will be put on? I column? What do you expect of the format of the result? Some kind of table? – Vylix Jun 5 '17 at 4:31

Re 1: Use conditional formatting with a formula. Select A1 to G1, create a new rule that uses a formula and use a formula that has an absolute reference to column H, like this


Then set a format for that rule. Repeat for other text values that you may have in column H.

Re 2: Not enough information to answer that. Split it out into a new question and post a data sample, along with expected results and logic explained in words.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.