I have set up conditional format to change the color of the text in a cell when Yes or No has been entered.
Yes changes the text color to Green and No changes the text color to green.
I would like all the text in the row to change color when I answer Yes or No in a specific cell.
The cell with the Yes?No is F1 I need to change color on A1-F1.
