#1
|
|||
|
|||
IF CELL VAlUE IS "?", THEN MAKE IT YELLOW
Dears,
how to make formula for; if any cell in A2:AF5000 is "?", then make cell in yellow color |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
thanks xor
|
#4
|
||||
|
||||
Cross-posted at:
https://www.mrexcel.com/forum/excel-...ke-yellow.html https://www.excelforum.com/excel-for...it-yellow.html https://www.excelguru.ca/forums/show...MAKE-IT-YELLOW For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
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 |