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.
Printable View
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:D Thanks again foz.in.oz;)Quote:
Originally Posted by foz.in.oz