Home Excel 2007 Format Good Use Of Conditional Formatting
Search MS Office A-Z   |   Search Web Pages/ Design A-Z

Good Use Of Conditional Formatting

I work for a company that requires me to keep accurate records of the cash exchanges at a number of events. To simplify things, I use Excel spreadsheets for the daily input and accumulation of the data in a single report form. To help the person entering the data into the worksheet, I tint all the spreadsheet cells light green and then set up conditional formatting to make it so that the background turns white when data is entered. To use conditional formatting in Excel 2007, click the cell to be formatted and click the Conditional Formatting button in the Styles section. In the drop-down menu, select Highlight Cell Rules, click the Greater Than option, and type 0 in the Format Cells That Are Greater Than field. Select the drop-down menu on the right, choose Custom Format, and click the White color (found in the Fill tab). Select OK, and when data is entered into the cell, the background will change to white, similar to the rest of the worksheet’s entered data.

Home Excel 2007 Format Good Use Of Conditional Formatting
Search MS Office A-Z   |   Search Web Pages/ Design A-Z