Conditional formating [Closed]

Question

Conditional formating [Closed]

Report

Ducky - Sep 3, 2016 at 07:05 PM
Mazzaropi

Posts: 1919
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: May 10, 2021

- Sep 3, 2016 at 09:57 PM

Hello,

I'm trying to make multiple cells turn red if a single cell has a certain value. So for example is B3 says "abc" cells B3:F21 should turn red. Is this possible?

Conditional formating
Excel conditional formatting if cell contains any date - How-To - Excel
Excel conditional formatting more than 3 colors ✓ - Forum - Excel
Conditional formatting merged cells ✓ - Forum - Excel
Conditional formatting if cell contains any text ✓ - Forum - Excel
Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel

1 reply

Ask a question

Mazzaropi · Answer 1 · 2016-09-03T21:57:52-0400

Answer 1 / 1

Mazzaropi

Posts: 1919
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: May 10, 2021

143
Sep 3, 2016 at 09:57 PM

Ducky, Good evening.

Try to do:

Select B3:F21 cells.

CF MENU --> NEW RULE --> USING FORMULA

Type it at field: =$B$3="abc"

Choose RED as fill format
OK

Please, tell us if it works for you.

Conditional formating [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!