Tag: conditional formatting
-
Conditional Formatting in Excel – Full Step-by-Step Guide (Using Employee Dataset)
Step 1: Enter the Dataset Create the following headers in Row 1: A B C D E F G H Emp ID Employee Name Department Sales Target Attendance % Rating Joining Date Enter the sample data in rows 2–21. Example 1: Highlight Sales Greater Than ₹100,000 Objective Highlight employees whose sales exceed ₹100,000. Steps Step