Copying Conditional Formating
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
|