Conditional formatting for different formulae

[Barbara H Wiseman]

I have found the following
http://www.j-walk.com/ss/excel/usertips/tip045.htm
for Identifing formulas using Conditional Formatting.
Does anyone know of a way of having different formatting depending on
the type of formula eg a column with IF and Sum formulae to give
different formatting for the IF and SUM cells.
Thanks very much if you can help.
Barbara

 

[Bob Phillips]

I gave you a solution to your exact same question that you posted in this
group yesterday at 20:13.

 

[David McRitchie]

Hi Barbara, (posted with email copy)
I expect the the use NOSPAM in email address may have interferred
with finding your own posts today. Anyway Bob's posting has made it to
Google Archives. Are you really using Google Groups to make
all of your newsgroup replies. Hadn't really looked to see if Google
had restarted doing newsgroup access or are you doing them through
the aGoogle Groups archives. Anyway...

http://google.com/[email protected]
=============================================

 

[David McRitchie]

Hi Barbara,
Just want to clarify, when you post through Google that you have
to wait a long time to see your posting anywhere using Google,
and that the only way you see that it went out immediately is
what you see on Outlook Express if you try this from home.
At home you would normally use OE as you did now. Is that
all correct or do you have another way of work to see that the
posting did go out..

When you use Google to work with newsgroups because of your
corporate firewall at work, what do you use to look at the
excel.misc -- are you dependent on postings being archived
before you reply. I looked at Google to see if they were supporting
newsgroups like Deja, if not mistaken, had in addition to archives and I couldn't
find anything. All I found after going through the supported
newsgroups was a link like:
http://groups.google.com/groups?hl=...newwindow=1&group=microsoft.public.excel.misc

which just puts you into the archives. In fact I couldn't even find
any note on supporting newsgroups or not supporting newsgroups
as a web based news browser.before postings are archived.

Google says archive in 1-4 hours my experience is wait 12 hours
and infrequently earlier..

 

[wiseman]

David,
Yes, I posted through google at work, hoping when I got home I would see the
posting on OE. When I did not I assumed the error message from google meant
it had not posted.
Our firewall at work is extremely rigorous as our division is in the defence
business. Others in the company can use a company news server in Sweden
while the UK one is down, but this is not a route we can use in our division
because of the firewall. Anyway even when the UK newserver is up it is
extremely patchy on non company newsgroups.
Thanks for your interest, I love the excel newsgroups.
Barbara

Hi Barbara,
Just want to clarify, when you post through Google that you have
to wait a long time to see your posting anywhere using Google,
and that the only way you see that it went out immediately is
what you see on Outlook Express if you try this from home.
At home you would normally use OE as you did now. Is that
all correct or do you have another way of work to see that the
posting did go out..

When you use Google to work with newsgroups because of your
corporate firewall at work, what do you use to look at the
excel.misc -- are you dependent on postings being archived
before you reply. I looked at Google to see if they were supporting
newsgroups like Deja, if not mistaken, had in addition to archives and I couldn't
find anything. All I found after going through the supported
newsgroups was a link like:
http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&newwindow=1&group=
microsoft.public.excel.misc

which just puts you into the archives. In fact I couldn't even find
any note on supporting newsgroups or not supporting newsgroups
as a web based news browser.before postings are archived.

Google says archive in 1-4 hours my experience is wait 12 hours
and infrequently earlier..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Unfortunately at work they do not have a functioning news feed at the
moment, a bit disappointing as there are some internal groups too, so google
groups are the only way to use newsgroups from there. I have used google
groups to post to newsgroups either at work and I used to use it to post to
microsoft.public.excel which has only just appeared on the Microsoft news
server.

I can see both of my posts on the Microsoft newserver, but the one via
google (from Barbara H Wiseman) appeared 12 hours later, even though it was
posted about 2 hours earlier. My google group postings in the past have
always appeared within a couple of minutes of posting (but are not visible
on google groups until a few hours later).