Previous Topic Next Topic

Conditional formatting

[Solved/Closed]
Report
Posts
2
Registration date
Monday April 8, 2013
Status
Member
Last seen
April 8, 2013
 -
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
 -
I am trying to maintain three lines of accounting on one spreadsheet. Basically, I have an order amount (C3) . I want to take that total from one of three lines of accounting either (E2, F2, or G2). I have created a pulldown (D3) and when I select which account from the pull down, which the text corresponds to the column headings of E,F or G, I want that choice to determine which account the amount (C3) is subtracted from.

3 replies

Answer 1 / 3
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
 486
Hi CrazieB317,

You don't need conditional formatting for that, just a formula:
in cell C3:
=IF(D3="EEE",E2,IF(D3="FFF",F2,G2))

Best regards,
Trowa
1
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Answer 2 / 3
Posts
2
Registration date
Monday April 8, 2013
Status
Member
Last seen
April 8, 2013
Thanks! I thought I tried that formula earlier but I guess I was entereing something wrong!
Answer 3 / 3
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
 486
Glad I could help.
Ask a question