Automatic Sl No.update to view one Specific Cell No.

Please see my attachment.

Required an excel formula to view the column C of red font only and put up an excel formula on column b

For an example:-

Look up the cell no.C5 ( should be RED font ) and mark in Column B as 1 and so on according to Ascending order as shown in Column B.

How is it possible ?