Accrington Web - View Single Post

andrewb · 17-05-2009, 19:38

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.

17-05-2009, 19:38	#2
andrewb God Member Join Date: Mar 2004 Location: Accrington Posts: 3,905 Liked: 1 times Rep Power: 920	Re: Spreadsheets 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. __________________ formerly cyfr