Personal Accounts - Conditional Formatting - Part 4

Hi People

The conditional formatting item is available on the 'Format' menu

The 'Conditional Formatting' option on the 'Format' menu

When you click on the 'Conditional Formatting' option, you will see the condition entry form

Several things to note here are

• the Condition 1 box is ticked, ready for the first entry
• there are 4 boxes of information required, to start with
• a maximum of 3 conditions are available

Click on the first box to change 'Cell value is' to 'formula is' 

When you change the 'Cell value is' to 'formula is', the middle box disappears, making way for a larger box into which you can type your calculation.  We are going to put the following calculation in

=OR(D7="d";D7="D")

The first calculation for the cell 

This will look familiar to you as it is one of the tests that make up the long calculation we studied several posts ago.  On clicking the 'New Style...' button you will find a window with 8 tabs.  Select the tab marked 'Background'

The 'Background' tab window

Select the red background for debits

Having selected the red background, by left clicking it, left click the 'OK' button and now left click in the 'Condition 2' box.  This will activate the second condition.

The two calculations for the conditional formatting styles (notice the third condition has not been activated)

Again change the 'Value is' to 'Formula is' and type in the formula

=OR(D7="c", D7="C")

Left click the 'New Style....' button and select a suitable green or blue color for the background of credits to the account.

Now left click the 'OK' button and let's test the results

From the picture below you can see what happens when you enter various credits and debits.

The final layout for the basic Home accounts program

Keep this spreadsheet handy as we will further develop it in a later post.

Next time we will look at the Writer program with Open Office.

Thank You for stopping by

Prometheus1618

We now have a FREE SPYWARE REPORT available, yours to keep and share if you wish. Fill in your details below and get yours now

eMail address:
First Name: