(A) By date
(B) By text contained in the cell
(C) By a number in the cell
By an image in the cell
Conditional formatting may be applied to a cell based on a date, text in the cell, or a number in the cell. Many spreadsheet applications have a function called conditional formatting that enables you to add particular formatting to cells that meet certain requirements. It’s most commonly used to highlight, emphasise, or separate data and details in a spreadsheet using color-based formatting.