Thread: [Solved] Conditional color fill based on presence of data
View Single Post
 
Old 07-28-2011, 09:10 AM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
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)
Reply With Quote