Conditional formatting

**cavinbaa** · 11-22-2014, 06:52 PM

HELP PIC.jpg

I want Cell A2 to fill with gray if the cell next to it (B2) contains "D-".
Same for A3 and B3
Same for A4 and B4
...and so on.

Can't seem to find the correct was to do this. I don't want the one rule for each cell... if it doesn't have a "D-" then it will not change.

Please help!

**FDibbins** · 11-22-2014, 06:55 PM

Hi, welcome to the forum

Your pic did not come through, and anyway please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you

Also, not all members can upload picture files (Company firewalls and stuff)

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

Having said that...

1. highlight the range you want to apply the conditional formatting to (the data in ciolumn A...but not the whole column, just your range)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$D2="D-"
format fill GREY

**cavinbaa** · 11-22-2014, 10:46 PM

I apologize on the picture. I have attached my document (at least I tried) and hope I can get some help.

I attempted your formula and I have to be doing something wrong... since nothing changes.

Notice in the file I already have some that are filled Gray... but those were all manually. I would love to have it autofill when the cell next to it contains "D-".

Thanks!

BC