newbie changing font color

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

News - 25 Dec 2005 22:13 GMT

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

Reply to this Message

Norman Jones - 25 Dec 2005 22:20 GMT

Hi News,

Excel's conditional format feature wiil do what you want.

See Debra Dalgleish's tutorial at:

http://www.contextures.com/xlCondFormat01.html

---
Regards,
Norman

> Dear group,
>
[quoted text clipped - 8 lines]
>
> Chris

Reply to this Message

brad_6663@hotmail.com - 25 Dec 2005 22:34 GMT

Choose cell D7

>From Menu

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

Reply to this Message

News - 26 Dec 2005 09:39 GMT

> Choose cell D7
>
[quoted text clipped - 12 lines]
>
> Brad

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
*************************

Reply to this Message

News - 26 Dec 2005 07:42 GMT

> Dear group,
>
[quoted text clipped - 8 lines]
>
> Chris

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

Reply to this Message

Norman Jones - 26 Dec 2005 10:22 GMT

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

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.

---
Regards,
Norman

>> Dear group,
>>
[quoted text clipped - 20 lines]
>
> Chris

Reply to this Message

News - 26 Dec 2005 10:56 GMT

> Hi News,
>
[quoted text clipped - 13 lines]
> Regards,
> Norman

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

Reply to this Message