Previous Topic Next Topic

Conditional formatting

Solved/Closed
CrazieB317 Posts 2 Registration date Monday 8 April 2013 Status Member Last seen 8 April 2013 - 8 Apr 2013 à 10:59
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 8 Apr 2013 à 12:03
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 responses

Réponse 1 / 3
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
8 Apr 2013 à 11:17
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
Réponse 2 / 3
CrazieB317 Posts 2 Registration date Monday 8 April 2013 Status Member Last seen 8 April 2013
8 Apr 2013 à 12:01
Thanks! I thought I tried that formula earlier but I guess I was entereing something wrong!
Réponse 3 / 3
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
8 Apr 2013 à 12:03
Glad I could help.

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response
Conditional formatting based text in another cell
y88y -
y88y -

2 responses
Conditional Formatting - highlight overdue dates
TanyaRT -
TanyaRT -

2 responses