Forum Discussion
Turn off condition formatting of a cell based on different cell
I updating the formulas a bit starting from row 12 and till end of the range.
In I12
=IF($G12="","",$G12-($H12+$I12)*7)it shows empty cells in column J if no req date (col G)
In K12
=IF(OR($M12<>"",$G12=""),"",J12-TODAY())It returns empty cell if no req date (column G) or order is closed (date in column M)
Conditional formatting:
All rules are expanded on entire range (not to generate bunch of new rules applying cell by cell with Format Painter) and one more rule on the top with "no color" if the cell is blank
Please check in attached file.
SergeiBaklan So from the attached file you can see I am tracking the progress for receiving a submittal. I have a date that I need to receive the document. I am comparing today's date to the need by date, and displaying the number of days remaining. I am them color coding the cell as the days grow shorter. Once I log a date into M11 announcing it has been received I need the tracking occurring in K11 to stop. That cell needs to display no number and return to white background.
So is that maybe having the formula in K11 first check for a value in M11 first, if valve-->stop, if no value proceed to run=DAYS(J11-J3). Conditional formatting I could do from there, no valve no formatting, whatever number --> formatting.
Thanks....
I updating the formulas a bit starting from row 12 and till end of the range.
In I12
=IF($G12="","",$G12-($H12+$I12)*7)it shows empty cells in column J if no req date (col G)
In K12
=IF(OR($M12<>"",$G12=""),"",J12-TODAY())It returns empty cell if no req date (column G) or order is closed (date in column M)
Conditional formatting:
All rules are expanded on entire range (not to generate bunch of new rules applying cell by cell with Format Painter) and one more rule on the top with "no color" if the cell is blank
Please check in attached file.
SergeiBaklan Thanks much for this. I am studying the formula trying to see what you have done. It is doing what I wanted, trying to learn something new. Again Thank you.....
GeneP , you are welcome. Please ask if something is unclear.