how can i change the color of a cell depending on the outcome of an IF clause ?
D Dion Oct 21, 2004 #1 how can i change the color of a cell depending on the outcome of an IF clause ?
A Alex Delamain Oct 21, 2004 #2 by using conditional formatting. You can either change the colour using the cell contents (e.g. if cel value = whatever) or you can put the if formula directly into the conditional forma itself
by using conditional formatting. You can either change the colour using the cell contents (e.g. if cel value = whatever) or you can put the if formula directly into the conditional forma itself
