Prev: Calc staff vacation time based on more than 1 criteria
Next: Removing disabled Macro
From: Luke on 6 May 2010 13:42
I am working in Microsoft 2007. I have a situation where I would like to use
the "red light, yellow light and green light" icons in the conditional
formating. However, I would like the icon to be placed into it's own cell.
My spreadsheet is generating a value and putting it into cell B1, lets say
the value is 1.4. In cell C1, I have manually put a value of 1.0. I would
like to use conditional formating so that one of the three icons shows up on
cell D1 based on the value of B1 in comparison to the value of C1.
Specifically if B1 is >= 1.0 then green, if B1 is between .99 and .90 then
yellow and below .9 then red.
Can you help? Thanks,

"Tree" wrote:

> THANK YOU SO VERY MUCH T. VALKO!! This was EXACTLY what I was looking for in
> my own situation... it is so wonderful that folks like you share your
> knowledge to folks like me!! THANK YOU!
>
> "T. Valko" wrote:
>
> > Try this:
> >
> > =AND(A1>16,A1<=19)
> >
> > Replace A1 with the actual cell reference
> >
> > --
> > Biff
> > Microsoft Excel MVP
> >
> >
> > "Ed R" <Ed R(a)discussions.microsoft.com> wrote in message
> > news:40CFB938-E4F7-43DD-8A46-BE5A05BCFAEB(a)microsoft.com...
> > > Is there a way to do this if you are looking for a range of values?
> > > Say
> > > - Turn Green if <=16
> > > - Turn Red if cell > 16 and <= 19
> > > - Turn Pruple of cell >19.
> > >
> > > I can't seem to get the middle rule to work. It will run the cell Green
> > > but
> > > I can't get the compound rule to cancel out the Green and make it red
> > >
> > >
> > > "T. Valko" wrote:
> > >
> > >> >I am using vista and excel 2007.
> > >>
> > >> Try this...
> > >>
> > >> Assume the cell in question is A1
> > >> Select cell A1
> > >> Goto Home tab>Styles>Conditional Formatting>Manage Rules
> > >> Click New Rule>Use a formula to determine.....
> > >> Enter this formula in the box: =A1="I"
> > >> Click the Format button
> > >> Select the desired style(s)
> > >> OK>OK>Apply
> > >>
> > >> Now, click New Rule and repeat the process for each of the conditions.
> > >>
> > >> This was much easier in previous versions of Excel!
> > >>
> > >>
> > >> --
> > >> Biff
> > >> Microsoft Excel MVP
> > >>
> > >>
> > >> "Shawn" <Shawn(a)discussions.microsoft.com> wrote in message
> > >> news:F6B1CFFE-B7DA-4E3A-A723-8E83720FF29F(a)microsoft.com...
> > >> >I have a similar question to this thread...
> > >> >
> > >> > I have a cell that contains an if statement that returns either I, II,
> > >> > III
> > >> > or IV depending on criteria. Can I also make the cell turn a different
> > >> > colour
> > >> > for each of these results? e.g. (Red for I, Orange for II, etc.) I used
> > >> > to
> > >> > know how to do this in the old excel, but now I am using vista and
> > >> > excel
> > >> > 2007.
> > >> >
> > >> > Thanks.
> > >> >
> > >> > Shawn
> > >> >
> > >> > "Miguel Zapico" wrote:
> > >> >
> > >> >> You can use Format->conditional formating, select "Formula is", and
> > >> >> insert
> > >> >> the condition that evaluates to true/false in the text box.
> > >> >>
> > >> >> Hope this helps,
> > >> >> Miguel.
> > >> >>
> > >> >> "George_Sky" wrote:
> > >> >>
> > >> >> > I want to identify a specific cell by highlighting it with a cell
> > >> >> > fill
> > >> >> > color
> > >> >> > when an "if" statement returns a "ture" response. How do I do this?
> > >>
> > >>
> > >>
> >
> >
> >
 | 
Pages: 1
Prev: Calc staff vacation time based on more than 1 criteria
Next: Removing disabled Macro