Previous Topic Next Topic

Conditional formating

Closed
Ducky - 3 Sep 2016 à 19:05
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 3 Sep 2016 à 21:57
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

Réponse 1 / 1
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
3 Sep 2016 à 21:57
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

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

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

26 responses
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response
Conditional formatting based text in another cell
y88y -
y88y -

2 responses
Conditional Formatting - highlight overdue dates
TanyaRT -
TanyaRT -

2 responses