it´s really sunny day here and neverthelles I ski with my family this winter
is little bit longer as should be.
BTW can I disturb you with any questions or comments of excel ? I need
somebody better as I am and I found some questions not being answered till
now to me.
Perhaps you know, Slovakia is in Central Europe - and I am in second largest
city in Slovakia - Kosice (Eastern Slovakia)
€žJulieD" napĂ*sal (napĂ*sala):
slovakia ... now that's a long way from Perth, Western Australia :) you
have a great day too
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"merlin68" wrote in message
...
thanks Julie a lot for the way with some light in tunnel. have a nice day
from Slovakia
"JulieD" napĂ*sal (napĂ*sala):
Hi Juraj
for one option - see http://www.mcgimpsey.com/excel/lookuppics.html
however, an "easier" solution might be to format the background colour of
the cell to red or green or whatever using conditional formatting,... say
you have the following IF in C1
=IF(A1B1,"yes","no")
and you want green for yes and red for no
click in cell C1 choose
format / conditional formatting
choose cell value is
type
yes
click on the format button - go to patterns choose a green
OK
click ADD
cell value is
type
no
click on format, go to patterns choose red
OK twice
however, if you just want the colour without words
delete the formula from C1
click in C1
choose format / conditional formatting
choose
formula is
type
=$A$1$B$1
click on format, go to patterns choose green OK
click on ADD
choose
formula
is
type
=$A$1<=$B$1
etc
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"merlin68" wrote in message
...
I know the format of IF function, however it is nicer after testing when
there is a picture showing as traffic light if it is allowed or not
allowed
to enter some numbers more ...
pls help me if you can
Juraj