Originally Posted by Claus Busch

Hi Jade,

Am Wed, 18 Jul 2012 19:19:57 +0000 schrieb Jade Summers:

I am hoping someone can teach me how to make it so that I can make a
conditional formatting formula that will check columns D and E to see if
D2 and E2 both say completed make green, If one says Required and one
says completed make yellow and if both are required make red. Leave
anything blank without a colour.

try:
first condition: =COUNTIF($D2:$E2,"required")=2 = color red
second condition: =COUNTIF($D2:$E2,"completed")=2 = color green
third condition:
=COUNTIF($D2:$E2,"completed")+COUNTIF($D2:$E2,"req uired")=2 = color
yellow


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2