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