Function Help
 

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.

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

<Format<Conditonal format is good for this

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

"Stuart" wrote:

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.

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


--
HTH

Bob Phillips

"Stuart" wrote in message
...
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.