Need cell color to equal text
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 |
Need cell color to equal text
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 "Skeetra27" wrote: 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 |
Need cell color to equal text
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 On Sat, 25 Jul 2009 07:17:01 -0700, Skeetra27 wrote: 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 |
Need cell color to equal text
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. "FloMM2" wrote: 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 "Skeetra27" wrote: 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 |
Need cell color to equal text
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. "Gord Dibben" wrote: 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 On Sat, 25 Jul 2009 07:17:01 -0700, Skeetra27 wrote: 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 |
Need cell color to equal text
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" wrote: 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. "Gord Dibben" wrote: 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 On Sat, 25 Jul 2009 07:17:01 -0700, Skeetra27 wrote: 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 |
Need cell color to equal text
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" wrote: 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" wrote: 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. "Gord Dibben" wrote: 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 On Sat, 25 Jul 2009 07:17:01 -0700, Skeetra27 wrote: 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 |
Need cell color to equal text
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" wrote: 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" wrote: 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" wrote: 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. "Gord Dibben" wrote: 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 On Sat, 25 Jul 2009 07:17:01 -0700, Skeetra27 wrote: 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 |
Need cell color to equal text
okay I will do that now
christine "FloMM2" wrote: 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" wrote: 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" wrote: 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" wrote: 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. "Gord Dibben" wrote: 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 On Sat, 25 Jul 2009 07:17:01 -0700, Skeetra27 wrote: 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 |
All times are GMT +1. The time now is 03:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com