If a2 is not empty, color empty cells in b2:af2

		Microsoft Office Forums > Microsoft Excel > Excel
If a2 is not empty, color empty cells in b2:af2

FAQ

Thread Tools

Display Modes

08-20-2017, 10:27 AM

turkanet

Windows 10 If a2 is not empty, color empty cells in b2:af2

Office 2016

Novice

Join Date: Aug 2017

Posts: 3

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:14 AM.