Wednesday, April 1, 2009

Yeast Infection Caused By Being Fingered




is a form where the amounts of the cells D26 and E26 are updated as they enter expenses and payments. The ending balances for debtors to creditors pass and vice versa as they changed the aggregate amounts. The company requires that when the balance of negative figures in D26 and E26 appear automatically in RED and when the balance is favorable, the figure displayed on BLACK.

The problem is solved using Conditional Formatting.


Condition 1: If the cell value is less than 0, bold red
Condition 2: If the cell value is greater than 0, bold black

0 comments:

Post a Comment