What to do IF need a cell to be highlighted in red, if multiple cells in another worksheet contain anything

[prince108]

I need to a cell (D3) on work sheet "Year Summary" to be colored red only if any of the following cells (C3:P4) contain anything (letters or numbers) in Worksheet "Jan 1-3".

I tried conditional formatting but pretty sure not using the right formula because its not working properly.

Please help thanks.

 

[StephenCrump]

Welcome to the Forum!

Try conditional formatting with the formula:

=COUNTA('Jan 1-3'!$C$3:$P$4)>0

or even more simply

=COUNTA('Jan 1-3'!$C$3:$P$4)

 

[prince108]

THank you! the first one works fine...