Conditional formating [Closed]

Report
-
Posts
1919
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 10, 2021
-
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?

1 reply

Posts
1919
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 10, 2021
143
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!