I want to use the IF formula. Don't know if this will make sense or not.
However, my example is as follows:

A B C D E
F G

DEBIT CREDIT
1 # DATE TRANSACTION DESCRIPTION (-) (+) BALANCE
2 7/1/06 Balance as of 7/1/06
$200.00
3 8/1/2006 SSI Deposit
$40.00 $240.00
4 802 8/2/06 Target - purchase $15.00
$225.00
5 803 8/2/06 Voided Check
$225.00
6 8/8/06 Deposit - Target Salary $130.00
$355.00
------------------------------------------------------------------------------------------
(Note: All dollar amounts shown here are false.) Conditional formatting
starts at cell B4. Formatting for this table is as follows:

Conditional formatting for C3:
Condition 1
Cell value is equal to ="SSI Deposit"
When condition is true: Font: Arial Font Style: Bold, & Cell shading: Bright
green.
I want to create a conditional format for cells B3 and D3 through F3 based
on the conditional format set in cell C3.
For example, the date is originally displayed as 1 - Aug, or August 1, 2006
Therefore I want the cell to be formatted as follows:

If C3="SSI Deposit" Then B3=Font: Arial, Font Style: bodl & Cell shading:
Bright green.

I also want to create a conditional format using the if functoin without
having to put the function in each cell. For example:

If C3="SSI Deposit" Then D3:F3=Font: Arial, Font Style: bodl & Cell shading:
Bright green.

Is it possible to do something like this?

--
John R. L.