_:n325bc084a6b54f598e4fd264ba810455xb2
<http://schema.org/text>
"- Highlight the first row (A thru X) and then go into conditional formatting\n- Choose the 'use a formula option' and in the box that appears type =$X1=2\n- Hit the Format button and select your formatting options\n- 'OK' yourself out of that function\n- Copy and Paste FORMATTING ONLY the first row all the way down thru all rows that need this conditional formatting.\n\nGive it a whirl :)"
<https://www.mrexcel.com/board/threads/conditional-formating.536276/>