Excel question...

without using conditional formatting, how can i get a cell to change colour in a standard IF statement, e.g.

IF(A1="Y","",WordingToChangeColour)

I'm sure there is a way of writing this into a formula - but i just cannot remember what it is. Each colour shade is designated a number, but it is what goes before (or after) it that is bugging me

Anyone??

Posted By: Yellalee, Nov 4, 15:18:29