Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting in text box | Excel Discussion (Misc queries) | |||
Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
conditional formatting with text | Excel Discussion (Misc queries) | |||
conditional formatting text | Excel Worksheet Functions | |||
Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) |