Conditional Formatting in Excel
Imaging being able to highlight one or more cells with colours or bold automatically when the value of cell exceeds 1000, wouldn't it be wonderful? And it makes your spreadsheet so intelligent!
A formatting that only applies if certain condition(s) are met. The formatting could be shading or cells or changing of font, color and size. Conditional formatting is particularly useful in highlighting one or more situations.
Creating Conditional Formatting:
1. Format>Conditional Formatting…
2. Specify condition(s)
3. Specify formatting (when conditions met)
A user can add one or more conditions into a cell or a range of cells.
A formatting that only applies if certain condition(s) are met. The formatting could be shading or cells or changing of font, color and size. Conditional formatting is particularly useful in highlighting one or more situations.
Creating Conditional Formatting:
1. Format>Conditional Formatting…
2. Specify condition(s)
3. Specify formatting (when conditions met)
A user can add one or more conditions into a cell or a range of cells.
posted by Wong RH at 4:40 PM
0 Comments:
Post a Comment
<< Home