Solved Excel highlight cell if another is highlighted

Microsoft Excel 2016 suites
February 17, 2017 at 06:50:57
Specs: Windows
Hi,
I need some help with excel.
I have a rule in Conditional Formatting that states all cells in B is highlighted light red if it doesn't contain the word House.
I need if possible C highlight in red as well if the corresponding cell in B is highlighted. Example B3 is red B4 is not while B5 is, then C3 and C5 would need to be highlighted as well.

See More: Excel highlight cell if another is highlighted

Reply ↓  Report •

#1
February 17, 2017 at 07:10:57
✔ Best Answer
Use the same rule, simply select column C in the "Applies to" section.

Or if you want to start over again:

1) Select your cell or range of cells: B1 : C100
2) On the ribbon click Conditional Formatting
3) Click on New Rules, it’s near the bottom of the dialog box.
4) Click Use Formula to determine which cells to format.
5) Enter the formula:

=$B1="House"

6) Click on the Format button
7) Select the Fill Tab
8) Select a pretty color
9) Click OK
10) Click OK

Note the Dollar Sign next to Column B in the formula,
it is necessary if you want both cells to turn color.
I only indicated 100 rows, B1:C100, change to suit your needs.

See how that works for you.

MIKE

http://www.skeptic.com/


Reply ↓  Report •
Related Solutions


Ask Question