[Solved] Conditional Formatting - Matching Columns in Bulk

Discuss the spreadsheet application

[Solved] Conditional Formatting - Matching Columns in Bulk

Postby GameDayDog » Fri May 24, 2019 4:38 pm

I may or may not be able to do this...

My brother has 2 checking accounts and I want to make sure that the total expenses matches the amounts from each bank.

Column B - Rows 3 - 8 ... He enters the amount spent. The sum is presented in cell B10.

In Rows 12 & 13 ... He enters if it was paid by the credit union or bank. That sum is presented in cell B14.

I want to make cell B14 turn red if it doesn't match cell B10. At this point it works great.

However, can I apply the formatting to the entire row without manually modifying the conditional formatting in each column?

Cell C14 is linked to B10. Cell D14 is linked to B10.
I need Cell C14 to link to C10 and D14 linked to D10, etc.

Am I missing something or simply asking for a feature that doesn't exist?

Thanks.
Attachments
Bank Format Test.ods
(13.68 KiB) Downloaded 12 times
Last edited by robleyd on Sun May 26, 2019 2:16 am, edited 2 times in total.
Reason: Add green tick
OpenOffice 4.1.6 on Windows 10
GameDayDog
 
Posts: 2
Joined: Fri May 24, 2019 4:13 pm

Re: Conditional Formatting - Matching Columns in Bulk

Postby FJCC » Fri May 24, 2019 4:59 pm

You can set conditional formatting in an array of cells in the following way.
1. Select all of the cells that you want to affect and notice which cell the cursor ends up in. Let's say you select B14:E14 and the cursor ends up in E14.
2. Go to the menu Format -> Conditional Formatting.
3. Set the first box to Formula Is.
4. Set the second box to the formula that will apply to the cell where the cursor is. In this case E14 <> E10.
5. Choose the Style to be applied with the formula returns TRUE. In this case, a style with a red background.
6. Click OK and all of the cells will have conditional formatting with the formula adjusted so that, for example, in column B the formula will be B14 <> B10
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7226
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Conditional Formatting - Matching Columns in Bulk

Postby GameDayDog » Sat May 25, 2019 4:53 pm

Thank you so much.. That worked perfectly!

AWESOMENESS!!!!
OpenOffice 4.1.6 on Windows 10
GameDayDog
 
Posts: 2
Joined: Fri May 24, 2019 4:13 pm


Return to Calc

Who is online

Users browsing this forum: unclebirt and 34 guests