Multiple cell conditional formatting using the IF
 

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.

Multiple cell conditional formatting using the IF
 

I can't figure out what your data looks like. Copying and pasting data
usually scrambles the format and it ends up being a jumbled mess.

When condition is true: Font: Arial Font

You can't change the font using conditional formatting but you can make it
bold and a different color. I'm pretty sure what you want to do can be done
but we need a better representation of your layout.


--
Biff
Microsoft Excel MVP


"John" wrote in message
...
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.

Multiple cell conditional formatting using the IF
 

Do you have an email address? I can create an example of what I am trying to
do so that you'll have a better Idea?
Please let me know ASAP.

Thank you,
--
John R. L.


"T. Valko" wrote:

I can't figure out what your data looks like. Copying and pasting data
usually scrambles the format and it ends up being a jumbled mess.

When condition is true: Font: Arial Font

You can't change the font using conditional formatting but you can make it
bold and a different color. I'm pretty sure what you want to do can be done
but we need a better representation of your layout.


--
Biff
Microsoft Excel MVP


"John" wrote in message
...
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.

Multiple cell conditional formatting using the IF
 

xl can help at comcast period net

Remove "can" and change the obvious.

--
Biff
Microsoft Excel MVP


"John" wrote in message
...
Do you have an email address? I can create an example of what I am trying
to
do so that you'll have a better Idea?
Please let me know ASAP.

Thank you,
--
John R. L.


"T. Valko" wrote:

I can't figure out what your data looks like. Copying and pasting data
usually scrambles the format and it ends up being a jumbled mess.

When condition is true: Font: Arial Font

You can't change the font using conditional formatting but you can make
it
bold and a different color. I'm pretty sure what you want to do can be
done
but we need a better representation of your layout.


--
Biff
Microsoft Excel MVP


"John" wrote in message
...
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.