I have a worksheet where if I type "yes" in a cell the line turns green, when I type "no" the line turns red. I am unclear on how to copy the conditional formatting from line to line. I have tried changing the range to encompass all the worksheet, but when I do that the whole worksheet changes according to the top right cell. I am attaching my work file. Any direction will be greatly appreciated. Thanks

Attached Files

CondFormatingTest.xlsx (9.0 KB, 11 views)

Change your conditions to =$G3=$X$2 and =$G3=$X$3 and apply to the entire range

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Pecoflyer You are fantastic. Thank you!