I need a help

[Frank Kabel]

Hi Auk
$%&/ (it was the Amarone in this case) copied your first answer and our
of habbit used the coma delimiter.

Speed of answer: Could be that the OP's clock is a little bit behind
the actual time

 

[A.W.J. Ales]

Hi Frank,

Speed of answer : No it wasn't.

I (this time checked) in Google. It was somewhat like 15:02 for the OP and
15:26 for your answer.
It just didn't show up before this morning and with those times in my
newsreader.
I notice that more often : there somehow seems to be a rather big timelag
between postings and their showing up in the thread in my reader.
Don't know what causes that and it's not always the case. I'll have to
dive into that as soon as I can spare the time for it.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Frank Kabel]

Hi
formulas are correct (and they work for me). Have you checked that the
COUNTIF statement is identical with the COUNTIF statement in the
conditional format dialog?

 

[Zdenka]

It is my example (a,b,c are columns)
A B C
620000 620000 =IF(COUNTIF($A$1:$A$1000;B1)=0;"*";"")
620000 620100 =IF(COUNTIF($A$1:$A$1000;B2)=0;"*";"")
620000 62300 =IF(COUNTIF($A$1:$A$1000;B3)=0;"*";"")
625004 625004 =IF(COUNTIF($A$1:$A$1000;B4)=0;"*";"")
Figures 620100 and 62300 are highlighted, but there is no * in column C

Did I make a mistake in formula, cause it
doesn't work!

thanks in advance!

 

[Zdenka]

In conditional formatting formula is =COUNTIF($A$1:$A$1000;B1)=0
and in column C in conditional formatting is
=IF(COUNTIF($A$1:$A$1000;B1)=0;"*";" ")

 

[Frank Kabel]

Hi
for column C don't use conditional formating
Just enter the formula
=IF(COUNTIF($A$1:$A$1000;B1)=0;"*";" ")
DIRECTLY in cell C1
then copy/drag this formula down

 

[Zdenka]

Frank thanks a lot, you resolved my big problem. My Balance Sheet has about
42000 rows with new accounts every day, thanks to you I'll see the new
accounts in a moment!!!!!