Cell Color Coding



I am having an issue where I have to color code yellow, green, or red cells in one row that are dependent on a target number. I am using conditional formatting but the issue is there are over 52 columns I need to create this. I seem to only be able to do one at a time. Is there a faster way.

Thank you.

Best Answer