Thread: [Solved] IF and Conditional Formatting - Ver.2003
View Single Post
 
Old 11-13-2011, 08:05 AM
Catalin.B Catalin.B is offline Windows Vista Office 2010 32bit
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
You can try something like this:
=IF(LEN(B2)>0;"COMPLETED";IF(MONTH(A2)<=6;"WD";IF( AND(MONTH(A2)>6;MONTH(A2)<12);"??";IF(MONTH(A2)>12 ;"BD";"Result if none of the above conditions is met"))))
then, you can use a conditional formatting formula like:
=$C2="WD"
Reply With Quote