newbie changing font color

N

News

Dear group,

I am a total newbie at Excel but have a reason to learn, so in at the
deep end. If I enter a number in say cell 28D and it is the same as the
number already in say Cell D7 then I want the number in D7 to change
color to highlight this fact, is this possible? If it is then I will
continue to learn as my goal may be acheived using excel, if not then I
must look for an alternate solution to the problem.

Regards

Chris
 
B

brad_6663

Choose cell D7
From Menu
Click to expand...

Format
Conditional Formatting
Choose "equal to" from second drop down menu
Enter D28 into next field
Select format button
Choose the format you require if condition is true. (Background colour
or font etc.)
Hope this gets you started

Regards

Brad
 
N

News

News said:
Dear group,

I am a total newbie at Excel but have a reason to learn, so in at the
deep end. If I enter a number in say cell 28D and it is the same as the
number already in say Cell D7 then I want the number in D7 to change
color to highlight this fact, is this possible? If it is then I will
continue to learn as my goal may be acheived using excel, if not then I
must look for an alternate solution to the problem.

Regards

Chris
Click to expand...

Thanks Norman and Brad, I suspected Excel was capable of what I wanted
to do, even if I had to learn a bit of visual basic. I will now go
through the tutorials. Out of interest my project is to automate our
office lottery scheme which is slightly different from the national one
and just for fun, but getting a little large now to check accurately
every time, and not being an office worker this is just some interesting
homework for me.

regards

Chris
 
N

News

Choose cell D7


Format
Conditional Formatting
Choose "equal to" from second drop down menu
Enter D28 into next field
Select format button
Choose the format you require if condition is true. (Background colour
or font etc.)
Hope this gets you started

Regards

Brad
Click to expand...

Thanks Brad

OK I have that bit working but run into another limitation (as I have to
learn in small steps), and that is that I can change the color of the
number in D7 if it is the same as the number entered into D28 but can't
also add into the condition (or E28,F28,G28 .... D29,E29 etc), I don't
expect you to do my "homework" for me and am learning all this from
scratch but any further pointers would be appreciated.

Basically my aim (or idea) is to be able to put everybody's lottery
numbers in a row of cells and as the lottery numbers are drawn these are
entered into other rows of cells (two times a week) and as lottery
numbers drawn match those chosen by participants so the numers in their
row changes colour. In our case it may take a few weeks before we get a
full coloured row (a winner).

Regards

Chris


*************************
Welcome to the Collective
The Future is BORG
*************************
 
N

Norman Jones

Hi News,
Thanks Norman and Brad, I suspected Excel was capable of what I wanted to
do, even if I had to learn a bit of visual basic
Click to expand...

Check the suggested Contextures tutorial.

Conditional formatting is an Excel feature and can be used without reference
to VBA.

I gave you the link so that you could further investigate the possibilities
of Conditional Formatting, which is a powerful and highly useful feature;
Brad provided you with an immediate solution which requires no programming.
 
N

News

Norman said:
Hi News,




Check the suggested Contextures tutorial.

Conditional formatting is an Excel feature and can be used without reference
to VBA.

I gave you the link so that you could further investigate the possibilities
of Conditional Formatting, which is a powerful and highly useful feature;
Brad provided you with an immediate solution which requires no programming.
Click to expand...

Thanks to both of you (and the writer of Contextures tutorial) I now
have a fully working prototype :)

Many thanks and best wishes for the New Year.

Chris
 
Top