Conditional Formatting (CF) is a tool that lets you apply formatting to a cell or a range of cells and have that formatting alter based on the cell's or formula's value. You can make a cell bold only when the value of the cell is more than 100, for example.
Select the cells to which conditional formatting should be applied. Drag from the first cell in the range to the last cell in the range.
Select HOME > Conditional Formatting > Highlight Cells Rules > Text that Contains from the drop-down menu.
Click OK after selecting the text's colour format.
Select Conditional Formatting > New Rule... from the Home tab of the ribbon. Select 'Select only cells that contain' from the drop-down menu. The first dropdown should be set to 'Cell Value.' From the second dropdown, choose 'greater than.'
Choose the cells, table, or entire sheet to which you want to apply conditional formatting. Select Conditional Formatting from the Home tab. Choose New Rule. Choose a style, such as 3-Color Scale, then select the criteria you want, then click OK.
Learner's Ratings
4.6
Overall Rating
81%
11%
5%
3%
0%
Reviews
S
Sayeed Arshif
5
Best
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
P
Prabhat Yadav
5
Superb and amazing 😍🤩 enjoyable experience.
P
pritam chakraborty
5
very good
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
Share a personalized message with your friends.