Forum Discussion
Eric Maddox
Nov 19, 2018Copper Contributor
Excel Formatting
Good morning.
I am attempting to format individual rows based on column D containing certain text - is this possible?
Row 1 is a header, working area (for now) is A2:J551.
If a cell in column D contains the text "OBS", I would like to strikeout the row containing that cell.
Thank you!
Hi Eric,
You may apply conditional formatting rule with formula as here to you range
and apply any format you wish, e.g.
3 Replies
- SergeiBaklanDiamond Contributor
Hi Eric,
You may apply conditional formatting rule with formula as here to you range
and apply any format you wish, e.g.
- Eric MaddoxCopper Contributor
Worked like magic!
Thank you, Sergei, very much appreciated.
Regards,
Eric
- SergeiBaklanDiamond Contributor
Eric, you are welcome