|
|||
Conditional Text is the tool suitable to format cells in a range/database based on a criterion For the following example, you will need a database and a decision table, as shows the image: |
|||
|
|||
use instructions: |
|||
|
|||
2.-Click on the OK button. The result is shown below: |
|||
![]() |
|||
| Notes: | |||
| If you wish to stop the automatic update , open the dialogue box again and quit check of the Auto-refresh.... | |||
| then press the button close in order to close the dialogue box. | |||
| The refreshing option applies only on the active sheet. |