View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

Try this ..

Assuming you have:

in L9: =IF(K10<0,"STOP",IF(K90,"GO","STOP"))
and L9 is copied down to L10

(So L9 returns: STOP, and L10 returns: GO for the sample data)

Put in the adjacent cell M9: =CHAR(ROW($A$152))
Copy down to M10

Select M9:M10
Format as: Wingdings 2
(this displays the "dots" in the default font color)

Now to make the dots change to red/green for STOP/GO

With M9:M10 still selected
Click Fornat Conditional Formatting

Condition1:
Formula Is | =L9="STOP"
Click Format Font tab Red / bold OK

Condition 2:
Formula Is | =L9="GO"
Click Format Font tab Green / bold OK

Click OK at the main dialog

M9:M10 will display the desired red / green dots
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"merlin68" wrote in message
...
I use following data :

here is formula for remark column
=IF(K10<0;"STOP";IF(K90;"GO";"STOP"))

DATA REMARK
-147 (K9) STOP
+300 (K10) GO

and IŽd like to put into remark the dot sign from wingdings2 font color

red
for STOP, otherwise dot signe from wingdigs font color green for GO

Pls help me how to combine together

Thanks / Juraj