| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make text in a cell equal a number | Excel Discussion (Misc queries) | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| Make text color match cell color with macro? | Excel Discussion (Misc queries) | |||
| How can I make an excel cell equal to the value of a text box | Excel Worksheet Functions | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
Hybrid Mode
