Re: Is there a way to create a "flag" in Excel 2007? by iliace
iliace
Sun Mar 16 01:12:44 CDT 2008
In Excel 2007:
Select all cells that have the total vehicle mileage in them. Next,
under the Home tab, in the Styles group, select Conditional
Formatting, and select Highlight Cells Rules. From there it's self-
explanatory - pick the option you need. If later there's a need to
edit these, go back to Conditional Formatting and select Manage Rules;
that will allow you to edit the range to which the formatting rule
applies, and the rule itself.
Hope this helps.
-Ilia
On Mar 15, 10:10=A0pm, "Tyro" <T...@hotmail.com> wrote:
> I expect the question to be in the body of the message. Sorry for your bei=
ng
> upset. Perhaps a good book on Excel, would take care of 99.9% of the OP's
> questions. But of course that would require work, as in opening the book a=
nd
> reading. I know it's hard.
>
> Tyro
>
> "MartinW" <m...@hotmail.invalid> wrote in message
>
> news:eMUr4mwhIHA.5208@TK2MSFTNGP04.phx.gbl...
>
> > And how about you doing the OP the courtesy
> > of reading the subject line of his/her post.
>
> > Since I don't know 2007 I'll leave it to
> > you to explain the process
>
> > Regards
> > Martin
>
> > "Tyro" <T...@hotmail.com> wrote in message
> >news:Q4_Cj.20768$Ej5.11607@newssvr29.news.prodigy.net...
> >> Sure. Compute the mileage and use conditional formatting to flag the
> >> mileage cell as a certain color when the mileage reaches 40,000. Since
> >> you don't do us the courtesy of telling us what version of Excel you ar=
e
> >> using, all I can tell you is you can find how to do conditional
> >> formatting in Excel help
>
> >> Tyro
>
> >> "CC" <C...@discussions.microsoft.com> wrote in message
> >>news:6FBC579E-F177-4783-B9E1-C8AC10993625@microsoft.com...
> >>>I am creating an expense worksheet for sales reps. =A0Beginning and end=
ing
> >>> mileage for company cars are entered each week. =A0Is there a way that=
> >>> Excel
> >>> can "flag" me once a vehicle reaches a certain mileage, i.e. 40,000
> >>> miles ???