Page 1 of 1

[Solved] Conditional Formatting - Matching Columns in Bulk

PostPosted: Fri May 24, 2019 4:38 pm
by GameDayDog
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.

Re: Conditional Formatting - Matching Columns in Bulk

PostPosted: Fri May 24, 2019 4:59 pm
by FJCC
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

Re: Conditional Formatting - Matching Columns in Bulk

PostPosted: Sat May 25, 2019 4:53 pm
by GameDayDog
Thank you so much.. That worked perfectly!

AWESOMENESS!!!!