excel question

[AHarvey]

Hi all,

Just wondering if it is possible to get a cell to automatically change colour depending on the numerical value inside the cell?

Using Excel 2007.

Thanks

 

[AHarvey]

After trawling through loads of pages I have found my answer, conditional formatting

Anyone any really indepth excel tutorial links for 2007??

 

[MarcLister]

Quite easy really. Go to a cell or cells, then click the conditional formatting button (I forget what tab it is under) then add a new rule and type the formula you want for the cell to go a different colour. So if the number is greater than 10 the cell goes red you'd want (A3>10) or something similar.

Google should get you a few tutorials for this.