I have an Excel Workbook, in which I have some information. What I actually want to know is if there is a way to highlight cells in a columns which have the word "Additional" in the cell above it.

For example there is a cell F8 which has "Additional" in it, so I would like to highlight F9. Similarly if Additional appears in F73, I would like to highlight F71 and so on.

Any help in this would be appreciated.

Thanks. ~K

CodePudding user response：

Try in CF rule

=F1="Additional"

and apply to from F2 cell like F2:F5000. See below screenshot.