Conditional formatting for different formulae

  • Thread starter Thread starter Barbara H Wiseman
  • Start date Start date
B

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
 
I gave you a solution to your exact same question that you posted in this
group yesterday at 20:13.
 
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]
=============================================
 
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..
 
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
 
Back
Top