DavidMontoya
06-02-2019, 04:05 AM
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="")))
=IF(IF(AND($M4=""),($W4=""),IF(AND($M4="N"),($W4=""),IF(AND($M4<>""),($W4<>"")))),"",IF(AND($M4<>""),($W4="")))
They both work fine independently; however, when join them together, as follows:
=IF(IF(AND($M4=""),($W4=""),IF(AND($M4="N"),($W4=""),IF(AND($M4<>""),($W4<>""),(IF(AND($Q4=""),($W4=""),IF(AND($Q4="N/A"),($W4=""),IF(AND($Q4<>""),($W4<>"")))))))),"",IF(AND($M4<>""),($W4=""),IF(AND($Q4<>""),($W4=""))))
only the first conditional formatting works, and the second portion do not work.
Thanks in advance for your help.
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="")))
=IF(IF(AND($M4=""),($W4=""),IF(AND($M4="N"),($W4=""),IF(AND($M4<>""),($W4<>"")))),"",IF(AND($M4<>""),($W4="")))
They both work fine independently; however, when join them together, as follows:
=IF(IF(AND($M4=""),($W4=""),IF(AND($M4="N"),($W4=""),IF(AND($M4<>""),($W4<>""),(IF(AND($Q4=""),($W4=""),IF(AND($Q4="N/A"),($W4=""),IF(AND($Q4<>""),($W4<>"")))))))),"",IF(AND($M4<>""),($W4=""),IF(AND($Q4<>""),($W4=""))))
only the first conditional formatting works, and the second portion do not work.
Thanks in advance for your help.