Dear,
Please help me with the following situation.
I need to have the following two conditional formatting to the same range W4 to W1004:
=IF(IF(AND($Q4=""),($W4=""),IF(AND($Q4="N/A"),($W4=""),IF(AND($Q4<>""),($W4<>"")))),"",IF(AND($Q4<>""),($W4="")))...