![]() |
#1
|
|||
|
|||
![]()
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 | 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 |
![]() |
Jamal NUMAN | Word | 1 | 09-03-2011 11:37 AM |
![]() |
Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
![]() |
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 |