In this Excel, I want to add these two conditions through conditional formatting.
Here, I have two conditions.
1.
Not more than 2 cells from B4 to B27 can fall below 65.
2. No cell can go below 55.
If more than 2 cells fall below 65 then only those cells falling below 65 will turn red.
If any cell falls below 55 then the cell will turn red. And these two conditions can be applied combinedly.
New_RPPF-CS-Dissolution Calculation Sheet for S1,S2 & S3.xlsx
Bookmarks