This might suffice ..
Select the range in col from D2 down (ie with D2 active)
then apply CF using Formula Is:
=AND(B2="Committed",LEFT(D2)+0=5)
Format to taste, ok out

Success? Celebrate it, hit YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"murkaboris" wrote:
I'm trying to do a conditional formatting for column that has multiple
variable descriptions and its not working....

The target formatting needs to be in column D and is dependend on column B &
D.
If B2="COMMITTED" and D2 is equal to or greater than "5-Advanced Solution" -
highlight D2 in green. The column D has descriptions from 1 to 10 but to each
number there is a "verbiage" attached similar to the 5...is it possible to
get the conditional formatting work?
(i.e. the rest of the column D options are --- "6-Confirm Solution",
"7-Final Proposal", "8-Close", "4-ID Strategy, "1-Create Interest"....so
anyting equal to or greater than 5 I would like to show in green if column B
shows "Committed")

Thank you.

Monika