Toggle navigation
View Course Overviews:
Excel
Word
Outlook
PowerPoint
AJ Training.net
Back
Filter by Software:
Excel
Outlook
PowerPoint
Word
How to use the AND formula?
Condition
Criteria
FALSE
Logic
TRUE
View
How to use the OR Formula?
Condition
Criteria
FALSE
Logic
TRUE
View
How to find the highest value based on one or multiple criteria?
Condition
Formulas
Highest
View
How to find the smallest value based on one or multiple criteria?
Condition
Formulas
Lowest
View
How to apply a colour to a cell if the value is lower than a certain figure?
Cells
Colour
Condition
Formatting
View
How to apply a colour to a cell if the value is higher than a certain figure?
Cells
Colour
Condition
Formatting
View
How to apply a colour to a cell if the value is between certain figures?
Cells
Colour
Condition
Formatting
View
How to apply a colour to a cell if the value is equal to a specified value?
Cells
Colour
Condition
Formatting
View
How to create a heat map using conditional formatting?
Colour
Condition
Formatting
View
1
Scroll