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

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

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

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

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

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