Need cell color to equal text

[Skeetra27]

Can I make a certain cell color in colum B4:B61 = "REG SHIFT" in column I4:I61?
The I column currently has a drop down list of several choices, including
REG SHIFT - this I do not want to change. Please advise.

Christine

 

[FloMM2]

Skeetra27,
This is what I came up with:
In cells I4:I61 "REG SHIFT" without ""
In cells B4:B61, select the color that you want the cell to become.
I chose sea green.
I put this formula in cell B4 "=IF($I4="REG SHIFT",1,0)"
This will put a sea green 1 in B4.
Select "Format", select "Conditional formatting..."
Choose "Cell Value Is" from drop down menu, choose "equal to" form drop down
menu,and type "1" in the last block along the top.
Select "Format..." button, select "Patterns" tab, and select sea green or
whatever color you chose earlier.
If you are happy with the results, copy B4 and paste from B5:B61
hth

 

[Gord Dibben]

Not clear what you want done but Conditional Formatting can be used to color
cells based on value in those cells.

See help on conditional formatting.


Gord Dibben MS Excel MVP

 

[Skeetra27]

This works the opposite way that I want it to. I already have text in each
cell from B4 through B61, each cell has NO FILL. I would like to know if I
can format a particular cell, say B5 with a color and then have that same
cell in the I column, I5, equal the text REG SHIFT. I am not sure if this
will be allowed since the I column contains a drop down menu (which does
include the text REG SHIFT)??? Basically I need the color in B column to
equal the text REG SHIFT in I column.

Also, if you can figure this out - I need to be able to choose a shift for
my department - say C SHIFT from a drop down menu or something and have C
shift equal each employee that is working that shift (approx 8-10 employees,
listed by last name only). I can make this list, but then I would like each
employee's name that is listed in column B AND listed in the drop down list
to be formatted by a color. Which in turn would then make the step above the
second half of this problem.

 

[Skeetra27]

I don't know if you can see the second post that I entered, but basically I
have a two part problem - the first question is if I can format a cell that
has text in it (column B, say B5) with a color and then have that color equal
REG SHIFT in the I column, I5. I don't know if this is possible.

 

[FloMM2]

Skeetra24,
Here goes try # 2.
I created a drop down list of "REG TIME", "OVER TIME", and "DOUBLE TIME".
Substitute what you need in your drop down list.
I put the drop down list in I4:I61.
I use "Conditional Formatting..." as follows:
Condition 1
Cell Value Is, not equal to, =($I4="REG TIME")
Format,Pattern, select green
OK
Add
Condition 2
Cell Value Is, not equal to, =($I4="OVER TIME")
Format,Pattern, select orange
OK
Add

Condition 3
Cell Value Is, not equal to, =($I4="DOUBLE TIME")
Format,Pattern, select red
OK
This will give you three options on colors to match your drop down list.
If it is what you meant, copy B4 to B5:B61 and copy I4 to I5:I61.
hth

 

[Skeetra27]

thank you for your help, but this is not what i want either(i already have
this done). i have to apologize, i am not able to explain clearly what i
would like.

 

[FloMM2]

Skeetra27,
If you would like, you can send the speadsheet to my personal email address
with a detailed description of what you would like done and I will try and
get it accomplished.
DLFollisthreeatnetscapedotnet
where three = 3
at = @
dot = .

 

[Skeetra27]

okay I will do that now
christine

Skeetra27,
If you would like, you can send the speadsheet to my personal email address
with a detailed description of what you would like done and I will try and
get it accomplished.
DLFollisthreeatnetscapedotnet
where three = 3
at = @
dot = .