LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 76
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting in text box pankaj Excel Discussion (Misc queries) 0 November 1st 07 09:09 AM
Conditional Formatting based on text within a cell w/ text AND num Shirley Excel Worksheet Functions 2 December 22nd 06 01:40 AM
conditional formatting with text Christine Hemphill Excel Discussion (Misc queries) 6 September 27th 06 09:53 PM
conditional formatting text kate Excel Worksheet Functions 4 September 1st 06 03:45 PM
Conditional Formatting based on Text within Text George Lynch Excel Discussion (Misc queries) 3 May 5th 05 07:58 PM


All times are GMT +1. The time now is 02:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"