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

		Microsoft Office Forums > Microsoft Excel > Excel
IF CELL VAlUE IS "?", THEN MAKE IT YELLOW

FAQ

Mark Forums Read

Thread Tools

Display Modes

08-20-2017, 05:36 PM

xor

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

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

Select A2:AF5000
Conditional Formatting
New rule
Use formula to determine which cells to format
In the field Format values where this formula is true, write: =A2="?" (no dollar signs)
Format, Fill, Yellow
OK you out.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
'Linking' entered information to other "cells" from an original "cell" in MS Word	Wade	Word	6	09-03-2012 05:22 PM
Mailing: how to make the "page number" in Word is the same as "row number" in excel w	Jamal NUMAN	Word	1	09-03-2011 11:37 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank?	Learner7	Excel	1	04-25-2011 04:39 AM
Make "Keep Text Only" the default past option in PP2003	powerpointbry	PowerPoint	0	09-17-2010 12:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:12 AM.