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
|