Excel Conditional Formatting

Hi, I’m currently trying to format cells in different columns so that when I select a duration option in one column, the rows in a different column are shaded.

For example, I have Duration as a heading in column C. Each row under column C has a little drop down box which gives you the option to select 1 week, 2 weeks, 3 weeks, 4 weeks, 5 weeks and 6 weeks.

What I’d like to do is link column C to columns F onwards, so that when 1 week is selected in column C, one cell is shaded in column F, when 2 weeks are selected, 2 cells are shaded in column F and G, when 3 weeks are selected, 3 cells are shaded in column F, G, H (each shaded cell representing a week).

Is this possible?

Thanks,

Aarti

 

By: Aarti

One thought on “Excel Conditional Formatting

  1. ig

    It is appropriate time to make some plans for the future and
    it is time to be happy. I’ve read this submit and if I may I want to suggest you some attention-grabbing issues or
    tips. Perhaps you could write next articles relating to
    this article. I desire to read even more things approximately
    it!

Comments are closed.