Conditional formatting in Excel helps to highlight important data and convert that part of the data into information. You can use colours and/or font style to highlight relevant data.
How to implement this feature step by step:
- Select the Excel cells to which you wish to apply 'formatting' based on some 'condition(s)'
- Click on 'Format' in the menu bar
- Select 'conditional formatting...'
- Define the condition(s) to apply
- Select the formatting style to apply if condition is true
- Finish the process by clicking 'ok' as shown in the Excel training video
|