IF CELL VAlUE IS "?", THEN MAKE IT YELLOW

[turkanet]

Dears,
how to make formula for;


if any cell in A2:AF5000 is "?", then make cell in yellow color

 

[JoeMo]

1. With your mouse, select A2:AF5000.
2. Home>Conditional Formatting>New Rule> Use a formula
3. Formula is: =A2="?"
4. Set the format to yellow fill
5. Press OK

 

[Kamolga]

Select A2:AF5000, then home tab / conditional formating.

Select the first option :"highlight cells rules"

In the coming menu, select "equals to...".

Type ? in the first part and in the arrow menu, select the last one "custom format...".

Go on last tab "fill" and select the yellow color.

Every cell where you type ? becomes yellow

 

[MARK858]

If the ? could be anywhere in the cell then using the same method as Kamolga has posted but using "Text that contains" rather than "equal to", type ~? rather than ? in the line below...

Type ? in the first part and in the arrow menu, select the last one "custom format...".

 

[turkanet]

Dears,
Thank you all

 

[Macropod]

Cross-posted at:
IF CELL VAlUE IS "?", THEN MAKE IT YELLOW
IF CELL VAlUE IS "?", THEN MAKE IT YELLOW
IF CELL VAlUE IS "?", THEN MAKE IT YELLOW
Please read Mr Excel's policy on Cross-Posting in rule 13: Forum Rules