I need a formula to plug into a cell in excel. I want the cell to contain the number 1 if any cell in a range of different cells is the color yellow.
Also, I need a separate conditional formatting formula. I want to have a cell turn red if a different cell has a numerical value > 0. The name of that other cell is CompItemsDone. Right now, the formula that isn't working for me is: ="CompItemsDone>0"