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?




By: Aarti

Leave a Reply

Your email address will not be published. Required fields are marked *