enter info in table...possible formula

C

carrie

I have an excel spreadsheet set up with columns for date, name, check#, etc.
To enter the information more efficiently as there is too many would be
the data -table...correct?

Then in each row the font is colored for example pre...is green....post is
red....
mixed is blue. So I was thinking of adding another column, so it would
become
part of the table to enter data. If I entered pre in there, how could I get
it
to change all data to say green?

I'm open to any suggestions!!

Thanks
 
S

SteveG

To have your font colors change use Conditional Formatting. Say your
table was A1:F3 where column F is where you assigned "pre", "post" or
"mixed". You could set up a Data Validation list in F1 for the "pre"
etc... Copy that down to F3. Then for the Conditional Formatting.
Highlight row A. Go to Format>Conditional Formatting. Change the Cell
Value Is to Formula is:

Condition 1: Green

=$F1="pre" Format>Patterns select the color. Click OK then Add.

Condition 2: Red

=$F1="post" Format>Patterns select the color. Click OK then Add.

Condition 3: Blue

=$F1="mixed" Format>Patterns select the color. Click OK then OK.

While the entire row is still highlighted, click on the Format Painter
and select the entire row 2 and 3.

As you change the option in column F from "pre", "post" and "mixed",
the formatting will change accordingly.

Does that help?

Steve
 
S

SteveG

Oops. Slight typo, to change the Font color, select the Font tab after
selecting Format, not Patterns.

HTH

Steve
 
C

carrie

Steve,

data validation list.....so I go to data...validation
and do what??
I'm in the first cell like you suggested F1 for example
do I pick custom and then do some kind of formula??

thanks,
carrie
 
C

carrie

Steve,

I DID IT!!!!!!!!!

Thank you. I keep working at it, and got it.
I sure appreciate your assistance.

Carrie
 
S

SteveG

Sorry I did not get back to you sooner, I had already left the office.
Glad you were able to figure it out.

Regards,

Stev
 
C

carrie

SteveG,

Seeing you are so excellent, can you assist me one more time?
I'm trying to make things as simple as possible for others.

Can I make, or how do you make a macro to bring up the form?
It's data - form - new. But when I get into the form and click new
it won't let me end the macro. Then when I hit esc and stop the macro
and run it it brings up a different form....not sure where that comes from.

Thanks,

Carrie
 
S

SteveG

Carrie,

Thanks for the flattery. Unfortunately, I don't use Forms that much.
I was able to record a macro that opened a form though. Same issues.
I had to hit Cancel before I could stop recording. I then assigne
that macro to a command button to run it. I ran into the same issu
where when the form popped up by clicking on the command button, th
user would have to click on New manually but it did not produce
"different" form. My labels were as when I recorded the macro. No
sure exactly what the issue might be. I am sure that someone in th
group must have some insight though. Hope you get the answer yo
need.

Regards,

Stev
 
Top