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.7
Overall Rating
82%
10%
5%
3%
0%
Reviews
I
Ibrahim Khalil
5
Very good
S
Sathi Nanda
5
Very good teaching quality
S
Soibol Debnath
5
It a very good course.
S
syed enterprise
5
thank you dear
S
Srijib Bhadra
5
MS Excel is a very important course, and it has helped me a lot in many ways
S
Sakibul Hasan Akash
5
"The teacher's presentation was very clear and well-organized. He tried to explain everything one by one. The teacher explained the topic very well and presented all the important points in a simple
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
Share a personalized message with your friends.