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
84%
9%
5%
2%
0%
Reviews
G
GM Salah Uddin
5
Thanks
M
MRIDHA MD MERAJ
5
Very good and Thank you so much
M
Md Mujahidul islam
5
This is a very good course.
M
Md Masud Rana
5
Good job
M
MD Yasin Khan
5
very helpfully for me thanke you learn vern team member
A
Abrar Hossen
5
I am happy for this course ....love you...I want to more course in bangla tutorial...from Bangladesh
Share a personalized message with your friends.