Formatting multiple columns based off a different cells value

**mrd1019** · 05-09-2013, 12:54 PM

Hi everyone, new guy here. I'm trying to apply some conditional formatting to an excel 2010 table and am having a lot of difficulty. Here's the breakdown.

There are going to be up to 3000 rows in the spreadsheet. I have a column, F, that is a drop-down menu for the users to select its value. Based on what they select, I need to apply formatting to a different section of the worksheet. For example, if they choose S4, then I need columns CV-DD to turn red in the corresponding row. There are about 8 different choices for column F, and each choice would cause a different portion of the spreadsheet to change its formatting. Once I figure out how to do one, the rest should be easy, but I can't get the first option that I described above to work.

Any help would be great. Thanks

**FDibbins** · 05-09-2013, 01:03 PM

Hi and welcome to the forum

You have this in the Outlook forum, but it looks like an excel question? I will move it to the correct forum for you

**mrd1019** · 05-09-2013, 01:06 PM

Thanks. Like I said, I'm the new guy.

**FDibbins** · 05-09-2013, 01:21 PM

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =F1=drop-down-choice1

repeat that for the other areas. It you will have to specific different ranges each time though

If you still have a problem, i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.