Hi Geert,
Say column J is the last column, the column with the YES for
outstanding debts, and your data base rows are from row 2 to row 100.
1. Select your database cells
2. Go FormatConditional formatting...
3. If the box below Condition 1 shows "Cell Value Is" click on the
arrow and select "Formula Is"
4. In the box to the right type =$J2:$J100 = "YES"
5. Click on the Format... button
6. Change the font color to red then click OK on the Format Cells
dialog
7. Click on the OK button on the Conditional Formatting dialog.

Ken Johnson