Conditional Formatting using variable text
 

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

Conditional Formatting using variable text
 

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

Conditional Formatting using variable text
 

Never mind -- I figured it out :)

=AND(B2="COMMITTED", D2<="5-Advanced Solution") .. worked like a charm

"murkaboris" wrote:

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

Conditional Formatting using variable text
 

Thanks Max, got it working.
Monika

"Max" wrote:

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

Conditional Formatting using variable text
 

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
---
"murkaboris" wrote:
Thanks Max, got it working.
Monika