CREATE CONDITIONAL RULES
CREATE CONDITIONAL RULES
It is used to highlight certain values or identify specific cells.
STEP 1:
Select the cells you want to add the format to.
STEP 2: On the Home tab, click the Conditional Formatting command. A drop-down menu will appear.
STEP 3:
Select the rule you want to use.For example, Mayor que
STEP 4: Enter a value in the space provided. In this example, we want to format cells whose value is greater than $ 300,000, so we are going to enter that number.
STEP 5: Select a format style
You will see that this is applied to the cells you selected.
CONDITIONAL RULES #1
Cindy Rodriguez
Created on February 12, 2021
Start designing with a free template
Discover more than 1500 professional designs like these:
View
Vaporwave presentation
View
Animated Sketch Presentation
View
Memories Presentation
View
Pechakucha Presentation
View
Decades Presentation
View
Color and Shapes Presentation
View
Historical Presentation
Explore all templates
Transcript
CREATE CONDITIONAL RULES
CREATE CONDITIONAL RULES
It is used to highlight certain values or identify specific cells.
STEP 1: Select the cells you want to add the format to.
STEP 2: On the Home tab, click the Conditional Formatting command. A drop-down menu will appear.
STEP 3: Select the rule you want to use.For example, Mayor que
STEP 4: Enter a value in the space provided. In this example, we want to format cells whose value is greater than $ 300,000, so we are going to enter that number.
STEP 5: Select a format style
You will see that this is applied to the cells you selected.