Soldato
hey, im learning quite a lot regarding formulas recently in my work but im struggling on a couple of things id like to do and its annoying me.
for example if i had a smiley face and a sad face i'd want to conditionally relate these to the value in another cell. how would i go about this? i've used conditional formatting a bit and even strayed into formulated conditional formatting but not with loose pictures. i figure if i could lock the picture to a cell then i could use that but i cant lock the images to cells in order to make the formulas point to them.
the other thing thats bugging me...
again its conditional formatting... how can i get an entire row to change colour if on of the cells is a certain value/range? and is it possible to change text type etc?
i can get the cells to display various text and include cell figures using multiple IF values e.g =if(A1=0,"yes","no",if(ifA1=1,"wtf?","haha")). i've even started using countif and roundup commands for stuff but its this conditional stuff thats doing me.
considering i started the job knowing SUM as about the only excel command i think i've done ok considering i've been self teaching myself but this is really annoying me.
for example if i had a smiley face and a sad face i'd want to conditionally relate these to the value in another cell. how would i go about this? i've used conditional formatting a bit and even strayed into formulated conditional formatting but not with loose pictures. i figure if i could lock the picture to a cell then i could use that but i cant lock the images to cells in order to make the formulas point to them.
the other thing thats bugging me...
again its conditional formatting... how can i get an entire row to change colour if on of the cells is a certain value/range? and is it possible to change text type etc?
i can get the cells to display various text and include cell figures using multiple IF values e.g =if(A1=0,"yes","no",if(ifA1=1,"wtf?","haha")). i've even started using countif and roundup commands for stuff but its this conditional stuff thats doing me.
considering i started the job knowing SUM as about the only excel command i think i've done ok considering i've been self teaching myself but this is really annoying me.