How do I make a formula to have the color change in a field?

When I have entered data in a few seperate fields, I want to make a green
color appear in another field so that my employees know that they filled the
other boxes in correctly and they can proceed with thier reservation form. I
have seen this before on other forms, but not sure how to make it work for
me. Thanks!

You can use conditional formatting for this

"Linds" wrote:

> When I have entered data in a few seperate fields, I want to make a green
> color appear in another field so that my employees know that they filled the
> other boxes in correctly and they can proceed with thier reservation form. I
> have seen this before on other forms, but not sure how to make it work for
> me. Thanks!

Use Conditional Formatting. See
http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Linds" <[email protected]> wrote in message
news:[email protected]...
> When I have entered data in a few seperate fields, I want to make a green
> color appear in another field so that my employees know that they filled
the
> other boxes in correctly and they can proceed with thier reservation form.
I
> have seen this before on other forms, but not sure how to make it work for
> me. Thanks!

It all depends on how many fields you have to fill in and what conditions
they must meet. For the cell you want to turn green you would go 'format'
.....'conditional formatting' You would then have to determine what
conditions have to be met in the cells that have had data entered into them.

"Linds" wrote:

> When I have entered data in a few seperate fields, I want to make a green
> color appear in another field so that my employees know that they filled the
> other boxes in correctly and they can proceed with thier reservation form. I
> have seen this before on other forms, but not sure how to make it work for
> me. Thanks!

Linds

Use Conditional Formatting.

Assume you enter data in A1 and want B1 to turn green if A1 is correct.

Select B1 and Format>CF>Formula is:

=$A$1="qwerty" or =$A$1=123

Pick a color from Format>Patterns and OK your way out.

To do several of these at a time, select multi-cells then Formula is:

=A1="qwerty"

Note the absence of the $ signs in second scenario.


Gord Dibben MS Excel MVP

On Tue, 11 Jul 2006 07:53:01 -0700, Linds <[email protected]>
wrote:

>When I have entered data in a few seperate fields, I want to make a green
>color appear in another field so that my employees know that they filled the
>other boxes in correctly and they can proceed with thier reservation form. I
>have seen this before on other forms, but not sure how to make it work for
>me. Thanks!