Explanation:

the basics of excel conditional formatting you can apply conditional formatting to one or several cells , rows, columns or the entire table based on the cell's value. you do this by creating rules (conditions) where you define when and how the selected cells should be formatted

i think this is helpful for u