Conditional color fill based on presence of data

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional color fill based on presence of data

FAQ

Thread Tools

Display Modes

#10

07-28-2011, 09:10 AM

Catalin.B

Windows Vista Conditional color fill based on presence of data

Office 2007

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

use this formula with the grey format
=AND(ISBLANK(H12)=TRUE;ISBLANK(I12)=TRUE;ISBLANK(J 12)=TRUE;ISBLANK(K12)=TRUE;ISBLANK(L12)=TRUE;ISBLA NK(M12)=TRUE;ISBLANK(N12)=TRUE;ISBLANK(O12)=TRUE;I SBLANK(P12)=TRUE;ISBLANK(Q12)=TRUE)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I fill the below emty cells with above cell data?	Learner7	Excel	8	06-28-2011 12:10 PM
Conditional data validation (list drop-down)	click4akshay	Excel	2	04-28-2011 01:51 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
Conditional Expression that Moves Data (challenging)	themangoagent	Excel	1	02-20-2010 11:29 AM
Change Automatic Fill Color	Leanne	PowerPoint	1	11-04-2009 08:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:21 AM.