[Solved] Conditional Formatting - Matching Columns in Bulk
Posted: 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.
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.