Ramon Salazar made the following query from Venezuela:
need to appear in red as DUE an invoice when a customer is and blue FORCE and when in the end.
This problem is solved by arming the nested conditional formula that appears in the toolbar.
= IF (B9 <> 0, IF ($ C $ 4-B9> C9 "EXPIRED", "FORCE ");"")
Cell C4 contains function TODAY () , which returns the date of day.
The = SI operates so that when a cell in the date column is empty, do not enter anything in the date column expiration.
To display the word EXPIRED RED and BLUE FORCE word, we must resort to conditional formatting. Paint
column which affect the form, go to FORMAT / FORMAT CONDITIONAL and once there, do the following:
0 comments:
Post a Comment