argument and Cell Color

[Tom]

I have created a spread sheet and in this spread sheet I have an argument
that if a true statement is made certain cells turn Red.

I forgot how I created this,,, I know I came here to get the answere but Its
been to long. and i cannot find where this takes place. It does not show in
a macro.

Can anyone help me find out how I did this?

Thanks in advance.
--
Tom from Penna

[Kevin B]

You can do this from the menu by clicking on DATA and selecting VALIDATION.
--
Kevin Backmann


"Tom" wrote:

> I have created a spread sheet and in this spread sheet I have an argument
> that if a true statement is made certain cells turn Red.
>
> I forgot how I created this,,, I know I came here to get the answere but Its
> been to long. and i cannot find where this takes place. It does not show in
> a macro.
>
> Can anyone help me find out how I did this?
>
> Thanks in advance.
> --
> Tom from Penna

[Tom]

Kevin
Thanks,,,, but this did not help when I clik on validate nothing comes back.
I maybe should have said that a range of cells turn red when the argument is
true.

--
Tom from Penna


"Kevin B" wrote:

> You can do this from the menu by clicking on DATA and selecting VALIDATION.
> --
> Kevin Backmann
>
>
> "Tom" wrote:
>
> > I have created a spread sheet and in this spread sheet I have an argument
> > that if a true statement is made certain cells turn Red.
> >
> > I forgot how I created this,,, I know I came here to get the answere but Its
> > been to long. and i cannot find where this takes place. It does not show in
> > a macro.
> >
> > Can anyone help me find out how I did this?
> >
> > Thanks in advance.
> > --
> > Tom from Penna

[Bob Phillips]

Sound like conditional formatting to me, Format>Conditional Formatting.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tom" <[email protected]> wrote in message
news:[email protected]...
> Kevin
> Thanks,,,, but this did not help when I clik on validate nothing comes
back.
> I maybe should have said that a range of cells turn red when the argument
is
> true.
>
> --
> Tom from Penna
>
>
> "Kevin B" wrote:
>
> > You can do this from the menu by clicking on DATA and selecting
VALIDATION.
> > --
> > Kevin Backmann
> >
> >
> > "Tom" wrote:
> >
> > > I have created a spread sheet and in this spread sheet I have an
argument
> > > that if a true statement is made certain cells turn Red.
> > >
> > > I forgot how I created this,,, I know I came here to get the answere
but Its
> > > been to long. and i cannot find where this takes place. It does not
show in
> > > a macro.
> > >
> > > Can anyone help me find out how I did this?
> > >
> > > Thanks in advance.
> > > --
> > > Tom from Penna