Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a formula to have the color change in a field?
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a formula to have the color change in a field?
Use Conditional Formatting. See
http://www.contextures.com/xlCondFormat01.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Linds" wrote in message ... 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a formula to have the color change in a field?
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a formula to have the color change in a field?
Linds
Use Conditional Formatting. Assume you enter data in A1 and want B1 to turn green if A1 is correct. Select B1 and FormatCFFormula is: =$A$1="qwerty" or =$A$1=123 Pick a color from FormatPatterns 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 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make fx field wider? | Excel Discussion (Misc queries) | |||
Is it possible to make a word in a formula bold? | Excel Worksheet Functions | |||
How do I make this formula? | Excel Discussion (Misc queries) | |||
Formula in a writable field | Excel Worksheet Functions | |||
Formula Help "Let me know if I do not make sence". | Excel Discussion (Misc queries) |