Function Help

[Stuart]

Is there a way I can use a function that will change the colour of required
cells to say, red?? e.g. using the IF, if two cells do not have the same
value a selected cell will change colour to red, to act as an alert.

 

[Dave O]

There is a way: check out conditional formatting in the Help feature.

 

[bj]

<Format><Conditonal format> is good for this

formula is =C1<>D1 and set format as you want it.

 

[Bob Phillips]

Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help