Multiple cell conditional formatting using the IF


J

John

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?
 
Ad

Advertisements

T

T. Valko

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.
 
J

John

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,
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top