Conditional Formatting based on multiple cells

[Sp8y8]

Hi,

Help required please...

I have an empty list P15:P38, (comments list) in sheet 2, If someone writes a comment, I would like cell P14 in Sheet 1 to have "***COMMENTS***" to appear in this cell, only when something is written in the "comments list" in sheet 2, remaining blank if there are no comments.

Any help appreciated.

Thanks

 

[Joe4]

That is not Conditional Formatting, that is a formula (Conditional Formatting only changes formatting, it cannot return values).

This is the formula you can put in cell P14 on Sheet1:

=IF(COUNTA(Sheet2!P15:P38)>0,"***COMMENTS***","")

 

[Fluff]

You cannot do that with conditional formatting, but you could use this formula

=IF(COUNTIFS(Sheet2!P15:P38,"<>"),"***COMMENTS***","")

 

[Sp8y8]

Thank you very much for your speedy response and your assistance with this.
Works perfectly.
Thank you again.

 

[Fluff]

Glad we could help & thanks for the feedback.