Previous Topic Next Topic

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

Answer 1 / 1
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.

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Conditional formatting several cells risk register
oyvinols -
fdibbins -

1 response
Applying conditional formatting rule to other rows
FrejaOlsen -
TrowaD -

1 response
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses