Conditional Formatting using variable text

  • Thread starter Thread starter murkaboris
  • Start date Start date
M

murkaboris

Hello:

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
 
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
 
Never mind -- I figured it out :)

=AND(B2="COMMITTED", D2<="5-Advanced Solution") .. worked like a charm
 
Thanks Max, got it working.
Monika

Max said:
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
Click to expand...
 
Glad to hear. If there's the possibility of more than a single digit for the
"front number" in col D (eg: 11-option eleven), you could try something like
this instead:
=AND(B2="Committed",LEFT(D2,SEARCH("-",D2)-1)+0>=5)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
Back
Top