Learn how to use conditional formatting to highlight cell.
In this video I will show you how to highlight cells that show sales value below 30%.
Here are the step from my short video.
1) Select cell area.
2) Ctrl + Q
3) Top 10%
4) Home --- Conditional Formatting --
Manage Rules
5) Double click Top 10%
6) Change Top to Bottom
7) Change 10 to 30
8) Ok (twice)
how to highlight cells in excel based on value,excel conditional formatting if cell contains multiple specific text,excel conditional formatting formula if,excel conditional formatting based on another cell multiple values,conditional formatting excel based on another cell,conditional formatting excel formula,excel conditional formatting based on another cell color,excel formula to change cell color based on text without conditional formatting,
#excel #tips #shorts #fyp
