Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-20-2017, 10:27 AM
turkanet turkanet is offline If a2 is not empty, color empty cells in b2:af2 Windows 10 If a2 is not empty, color empty cells in b2:af2 Office 2016
Novice
If a2 is not empty, color empty cells in b2:af2
 
Join Date: Aug 2017
Posts: 3
turkanet is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 08-20-2017, 05:39 PM
xor xor is offline If a2 is not empty, color empty cells in b2:af2 Windows 10 If a2 is not empty, color empty cells in b2:af2 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,037
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

See thread:

https://www.msofficeforums.com/excel...ke-yellow.html
Reply With Quote
  #3  
Old 08-20-2017, 11:00 PM
macropod's Avatar
macropod macropod is offline If a2 is not empty, color empty cells in b2:af2 Windows 7 64bit If a2 is not empty, color empty cells in b2:af2 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,071
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
If a2 is not empty, color empty cells in b2:af2 How to get rid of empty cells. nicholes Excel 7 12-23-2013 06:27 PM
If a2 is not empty, color empty cells in b2:af2 Empty cells plotted as zero. ColinC Excel 3 03-04-2013 04:57 AM
If a2 is not empty, color empty cells in b2:af2 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
If a2 is not empty, color empty cells in b2:af2 Vba, Is there a better way to test empty cells? Hwyn Excel Programming 2 11-14-2011 11:44 AM


All times are GMT -7. The time now is 02:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft