| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text conditional formating
I have been trying to do the following and cant get it right:
in a (validation) list H5 through h168, i have 6 different names, in a J5 through j168 , i want the cell in j5 to turn the color of the text, ie: h5 has Figdore, in J5 I want the name Blue to come up and make that cell a blue colo. h5 figdore = j5 blue h6 jackson = j6 pink Please help, thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text conditional formating
If I correctly understand what you're looking for, you need to:
In J5, put the formula: =IF(H5="Figdore", "Blue", "") Then conditionally format J5 to color blue when the cell value is "Blue" "hannatrip" wrote: I have been trying to do the following and cant get it right: in a (validation) list H5 through h168, i have 6 different names, in a J5 through j168 , i want the cell in j5 to turn the color of the text, ie: h5 has Figdore, in J5 I want the name Blue to come up and make that cell a blue colo. h5 figdore = j5 blue h6 jackson = j6 pink Please help, thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text conditional formating
when i put this in j5 I get a message: The value you entered is not valid?
"Vergel Adriano" wrote: If I correctly understand what you're looking for, you need to: In J5, put the formula: =IF(H5="Figdore", "Blue", "") Then conditionally format J5 to color blue when the cell value is "Blue" "hannatrip" wrote: I have been trying to do the following and cant get it right: in a (validation) list H5 through h168, i have 6 different names, in a J5 through j168 , i want the cell in j5 to turn the color of the text, ie: h5 has Figdore, in J5 I want the name Blue to come up and make that cell a blue colo. h5 figdore = j5 blue h6 jackson = j6 pink Please help, thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text conditional formating
Sounds like there's a validation rule in J5. If "Blue" isn't an allowed
value in J5 then, it wouldn't work according to your needs. "hannatrip" wrote: when i put this in j5 I get a message: The value you entered is not valid? "Vergel Adriano" wrote: If I correctly understand what you're looking for, you need to: In J5, put the formula: =IF(H5="Figdore", "Blue", "") Then conditionally format J5 to color blue when the cell value is "Blue" "hannatrip" wrote: I have been trying to do the following and cant get it right: in a (validation) list H5 through h168, i have 6 different names, in a J5 through j168 , i want the cell in j5 to turn the color of the text, ie: h5 has Figdore, in J5 I want the name Blue to come up and make that cell a blue colo. h5 figdore = j5 blue h6 jackson = j6 pink Please help, thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text conditional formating
yeah i fixed it!! but now how do i do this for the rest of the people on the
drop down list in h5? johnson, unwin,lawrence,figdore shuold all be blue jackson,gerlach,keperling,benoit-wilson should all be pink "Vergel Adriano" wrote: Sounds like there's a validation rule in J5. If "Blue" isn't an allowed value in J5 then, it wouldn't work according to your needs. "hannatrip" wrote: when i put this in j5 I get a message: The value you entered is not valid? "Vergel Adriano" wrote: If I correctly understand what you're looking for, you need to: In J5, put the formula: =IF(H5="Figdore", "Blue", "") Then conditionally format J5 to color blue when the cell value is "Blue" "hannatrip" wrote: I have been trying to do the following and cant get it right: in a (validation) list H5 through h168, i have 6 different names, in a J5 through j168 , i want the cell in j5 to turn the color of the text, ie: h5 has Figdore, in J5 I want the name Blue to come up and make that cell a blue colo. h5 figdore = j5 blue h6 jackson = j6 pink Please help, thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text conditional formating
Specify 2 conditions for the conditional format. Blue condition formula is:
=OR(H5="Johnson", H5="Unwin", H5="Lawrence", H5="Figdore") Pink condition formula is =OR(H5="Jackson", H5="Gerlach", H5="Keperling", H5="Benoit-Wilson") "hannatrip" wrote: yeah i fixed it!! but now how do i do this for the rest of the people on the drop down list in h5? johnson, unwin,lawrence,figdore shuold all be blue jackson,gerlach,keperling,benoit-wilson should all be pink "Vergel Adriano" wrote: Sounds like there's a validation rule in J5. If "Blue" isn't an allowed value in J5 then, it wouldn't work according to your needs. "hannatrip" wrote: when i put this in j5 I get a message: The value you entered is not valid? "Vergel Adriano" wrote: If I correctly understand what you're looking for, you need to: In J5, put the formula: =IF(H5="Figdore", "Blue", "") Then conditionally format J5 to color blue when the cell value is "Blue" "hannatrip" wrote: I have been trying to do the following and cant get it right: in a (validation) list H5 through h168, i have 6 different names, in a J5 through j168 , i want the cell in j5 to turn the color of the text, ie: h5 has Figdore, in J5 I want the name Blue to come up and make that cell a blue colo. h5 figdore = j5 blue h6 jackson = j6 pink Please help, thanks |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text conditional formating
thank you sooo much!!
"Vergel Adriano" wrote: Specify 2 conditions for the conditional format. Blue condition formula is: =OR(H5="Johnson", H5="Unwin", H5="Lawrence", H5="Figdore") Pink condition formula is =OR(H5="Jackson", H5="Gerlach", H5="Keperling", H5="Benoit-Wilson") "hannatrip" wrote: yeah i fixed it!! but now how do i do this for the rest of the people on the drop down list in h5? johnson, unwin,lawrence,figdore shuold all be blue jackson,gerlach,keperling,benoit-wilson should all be pink "Vergel Adriano" wrote: Sounds like there's a validation rule in J5. If "Blue" isn't an allowed value in J5 then, it wouldn't work according to your needs. "hannatrip" wrote: when i put this in j5 I get a message: The value you entered is not valid? "Vergel Adriano" wrote: If I correctly understand what you're looking for, you need to: In J5, put the formula: =IF(H5="Figdore", "Blue", "") Then conditionally format J5 to color blue when the cell value is "Blue" "hannatrip" wrote: I have been trying to do the following and cant get it right: in a (validation) list H5 through h168, i have 6 different names, in a J5 through j168 , i want the cell in j5 to turn the color of the text, ie: h5 has Figdore, in J5 I want the name Blue to come up and make that cell a blue colo. h5 figdore = j5 blue h6 jackson = j6 pink Please help, thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONDITIONAL FORMATING FINDING TEXT CONTAINING SPECIFIC NUMBERS | Excel Worksheet Functions | |||
| Conditional formating with TEXT | Excel Discussion (Misc queries) | |||
| Conditional formating based on text | Excel Worksheet Functions | |||
| Conditional Formating when result is text | Excel Worksheet Functions | |||
| conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) | |||
Linear Mode
