Spreadsheets

[K.S.H]

Who's a spreadsheet expert?

I want a cell and text to change colour when 3 other cells match, done it before but can't for the life of me remember how

[andrewb]

I don't have excel to try it but from what I remember..

Click the cell, click format and conditional formatting.

Use the formula

=IF($A$1=$A$2)AND($A$2=$A$3)

Then there should be somewhere to set the colour you wish the cell to turn on the condition that this formula is met. Hopefully this will work, it's certainly along the right lines, I just haven't used spreadsheets for ages.

I suspect there's probably a 'better' way to do the formula.

[K.S.H]

I did it with the conditional formatting, should have updated the post!
Thanks anyway

PS - Excel, whats that