#1
|
|||
|
|||
If a2 is not empty, color empty cells in b2:af2
Dear All,
Would you ple help me for below formula request? if A2 is not empty, then make empty cells RED COLOR in B2:AF2, and apply this rule to A2:AF5000 |
#2
|
|||
|
|||
|
#3
|
||||
|
||||
Cross-posted at:
https://www.mrexcel.com/forum/excel-...ls-b2-af2.html https://www.excelguru.ca/forums/show...3848#post33848 https://www.excelforum.com/excel-for...in-b2-af2.html For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184 Note: This is the second thread where you have ignored the cross-posting rules on this and other sites. Kindly read and comply with the rules of ALL forums you subscribe to.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to get rid of empty cells. | nicholes | Excel | 7 | 12-23-2013 06:27 PM |
Empty cells plotted as zero. | ColinC | Excel | 3 | 03-04-2013 04:57 AM |
Word Empty Cells - Why is it Chr(13) & Chr(7) | tinfanide | Word VBA | 2 | 04-10-2012 01:34 AM |
Apparently empty (blank) cells aren't empty | daymaker | Excel | 3 | 03-08-2012 03:41 PM |
Vba, Is there a better way to test empty cells? | Hwyn | Excel Programming | 2 | 11-14-2011 11:44 AM |