I have a spreadsheet with multiple formulas in it, working well.
Cell C6, and D6 both require amounts added to complete the calculation into N6 (N6 has a formula in it the captures other cells to calculate a total.
I would like the following if possible
that if either C6 or D6 is empty the cell N6 will show with a yellow background, but if the both have a value the N6 will have no coloured background
I believe conditional formatting may be able to achieve this, but have no history in using it
Any help appreciated
Cell C6, and D6 both require amounts added to complete the calculation into N6 (N6 has a formula in it the captures other cells to calculate a total.
I would like the following if possible
that if either C6 or D6 is empty the cell N6 will show with a yellow background, but if the both have a value the N6 will have no coloured background
I believe conditional formatting may be able to achieve this, but have no history in using it
Any help appreciated