Edit: Split from [Solved] Conditionally format cells in row after L or P because that topic was solved so you need a new topic for a new question. -- MrProgrammer, forum moderator |
Ok, that solved one of my issues on positioning and it worked great, however, I had a 2nd conditioning formula on three of the fields, that had to do with dollar amount
It's IF ( AND ($B15>0;$B15<120)) which results in a blackout
The other conditioning format is (from earlier discussion)
SUMPRODUCT($C12:T12="L")+SUMPRODUCT($C12:T12="P") which results in a blackout
But no matter what I do, even flipping which formula is first or which is second, that condition on $B doesn't work..
Am I able to put these two conditional formats together??