I want to apply a conditional format to cell B16 to make the fill color change to another color.
I can make it happen if I just use one single reference such as C16 but then I would have to create a conditional reference for the rest of the cells D16:N16
What would the formula look like to change the color of the fill in cell B16 if any of the cells in range C16:N16 =1. It seems to me I need to be using an IF OR statement but I can't seem to get it to work.
Thanks for the Help
Bookmarks