In Excel, you can enter "conditional formatting" to a cell to make the cell contents show in a different color or font kind/size when it meets or does not meet your specific criteria. For instance, you can set the cell to show in RED if the data is less than 5% of the data in a cell elsewhere in your workbook.
A common problem is the copying/pasting of conditional formatting to other cells. If you find the pasting not working properly, be sure you are pointing to cell named $E5 (for instance) instead of $E$5.
No comments:
Post a Comment