Thread: Assigning a # value to a letter in Excel 2007

Select the cell that you want to configure and then goto the FORMAT menu and select CONDITIONAL FORMATTING. A dialog box will appear that allows you to set upto three rules for the data. Have a play and if you need more help just ask.

Originally Posted by foz.in.oz

Select the cell that you want to configure and then goto the FORMAT menu and select CONDITIONAL FORMATTING. A dialog box will appear that allows you to set upto three rules for the data. Have a play and if you need more help just ask.

What a great tool...........I will be here some time applying some of these tricks to a few of my spreadsheets Thanks again foz.in.oz