Conditional formating

Closed
Ducky - Sep 3, 2016 at 07:05 PM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- 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?

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
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.
0