Re: function IF / how to input pictures into this functions /

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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(A1>B1,"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" <tckmke@xxxxxxxxxxx> wrote in message
news:9D1D8DA0-B436-4F79-A4F0-855C00F38C5D@xxxxxxxxxxxxxxxx
>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
> mer68@xxxxxxxxx


.

Quantcast