Question

which option in conditional formatting is suitable for highlighting Abjent and present in attendance sheet​

Answer 1

=$A2<$B2 - format cells or rows if a value in column A is less than the corresponding value in column B. =$A2=$B2 - format cells or rows if values in columns A and B are the same. =$A2<>$B2 - format cells or rows if a value in column A is not the same as in column B.

hope it helps u

#NAWABZAADI

Answer 2

Apply conditional formatting to text

Apply conditional formatting to textSelect the range of cells, the table, or the whole sheet that you want to apply conditional formatting to.

Apply conditional formatting to textSelect the range of cells, the table, or the whole sheet that you want to apply conditional formatting to.On the Home tab, click Conditional Formatting, point to Highlight Cells Rules, and then click Text that Contains.