Conditional Formatting a cell based on an entire row.

Closed
Nick - Mar 27, 2015 at 10:21 AM
I'm trying to set up a sheet where I have field names in column A, rows 2-20, and dates in row 1 from column B to CD. This format works great for what I need it for, but I'd like to set up conditional formatting so that if an "O" is found under any date in same row as a field, the field name cell in column A turns orange, and if a "C" is found under any date the the field name cell turns blue. However I try it, =$B$2:$CD$2="O" or =B$2:CD$2="O" or $B2:$CD2="O" or any combination, A2 will only turn orange if there is an "O" in B2, if there is an "O" anywhere in C2 through CD2 nothing happens. Is there a way to do this without setting up a ridiculous amount of rules, basically one for every date?