Help with conditional formatting a cell

[Kiwi den]

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

 

[Fluff]

Select N6 & in conditional formatting select new rule > Use a formula > & enter this

=OR(C6="",D6="")
Then select your format.

 

[Kiwi den]

Select N6 & in conditional formatting select new rule > Use a formula > & enter this

=OR(C6="",D6="")
Then select your format.

Thanks, sort of works as I want, however I would still want N6 to be yellow if c6 is empty but D6 has a value or visa versa

 

[Fluff]

That's what the formula does. If either C6 or D6 are blank, then N6 will be yellow.
Do you have a formula in C6 & D6?

 

[Kiwi den]

Thanks all sorted, Thank you works a treat!

 

[Fluff]

You're welcome & thanks for the feedback.