enter info in table...possible formula
 

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

enter info in table...possible formula
 

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 FormatConditional Formatting. Change the Cell
Value Is to Formula is:

Condition 1: Green

=$F1="pre" FormatPatterns select the color. Click OK then Add.

Condition 2: Red

=$F1="post" FormatPatterns select the color. Click OK then Add.

Condition 3: Blue

=$F1="mixed" FormatPatterns 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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=524546

enter info in table...possible formula
 

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

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=524546

enter info in table...possible formula
 

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


"SteveG" wrote:


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

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=524546

enter info in table...possible formula
 

Steve,

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

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

Carrie

"SteveG" wrote:


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

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=524546

enter info in table...possible formula
 

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

Regards,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=524546

enter info in table...possible formula
 

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
"SteveG" wrote:


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

Regards,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=524546

enter info in table...possible formula
 

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 assigned
that macro to a command button to run it. I ran into the same issue
where when the form popped up by clicking on the command button, the
user would have to click on New manually but it did not produce a
"different" form. My labels were as when I recorded the macro. Not
sure exactly what the issue might be. I am sure that someone in the
group must have some insight though. Hope you get the answer you
need.

Regards,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=524546