Matt H
23-11-07, 16:07
Need a bit of advice on how to do something in excel for work.
Basically, i need a cell to change colour based upon the numeric value thats in it, i.e, if D9=5 then D9 should then be filled red for exampe.
Does anyone know how to do this? being trying an IF command but cant seem to find anything that would produce a colour fill :(
Ta
Matt
Basically, i need a cell to change colour based upon the numeric value thats in it, i.e, if D9=5 then D9 should then be filled red for exampe.
Does anyone know how to do this? being trying an IF command but cant seem to find anything that would produce a colour fill :(
Ta
Matt