Conditional formating

Closed
Ducky - Sep 3, 2016 at 07:05 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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