i answered at excelforum as well as here - just for completeness, dont usually reply to both , as it can get confusing if other people answer on the forums
BUT as its just me , i have answered BOTH
you have 2007 as the version in this forum and 2010 on the other forum, BUT you also spoecify in a post that its for 2010 version
please update profile , as different versions have different functions available
EDIT
XL2BB does not like the formatting you choose and so its BLACK - i changed to a different FILL
as you said it was a 2010 version
i used 2 conditional formatting rules
selected C4 to c10000
and used
$C4=$F$1
2nd RULE
Selected D4 to G10000
and used
=AND($C4=$F$1,D4<>"")
for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting
Highlight applicable range >>
C4:C10000 - Change, reduce or extend the rows to meet your data range of rows
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
$C4=$F$1
Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK
Then added a new rule
for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting
Highlight applicable range >>
D4:G10000 - Change, reduce or extend the rows to meet your data range of rows
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND($C4=$F$1,D4<>"")
Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK
exc con fort (2).xlsx |
---|
|
---|
| A | B | C | D | E | F | G | H |
---|
1 | | | | | | HDFC card Payment | ₹ 13,558.00 | |
---|
2 | | | | | | | | |
---|
3 | DATE | BANK NAME | PAYEE | FEDERAL DEPOSIT | FEDERAL DEBIT | S B I DEPOSIT | S B I DEBIT | BALANCE |
---|
4 | 01-Apr-2024 | STATE BANK OF INDIA | Opening Balance | | | | | ₹ 48,654.50 |
---|
5 | 01-Apr-2024 | FEDERAL BANK | Opening Balance | | | | | ₹ 91,741.51 |
---|
6 | 02-Apr-2024 | FEDERAL BANK | HDFC card Payment | | 4341 | | | ₹ 136,055.01 |
---|
7 | 02-Apr-2024 | STATE BANK OF INDIA | Gas Refund | | | 19.57 | | ₹ 136,074.58 |
---|
8 | 05-Apr-2024 | STATE BANK OF INDIA | Salary | | | 35000 | | ₹ 171,074.58 |
---|
9 | 07-Apr-2024 | STATE BANK OF INDIA | ICICI Card payment | | | | 10260 | ₹ 160,814.58 |
---|
10 | 13-Apr-2024 | STATE BANK OF INDIA | Cash Withdrawal | | | | 3000 | ₹ 157,814.58 |
---|
11 | 16-Apr-2024 | STATE BANK OF INDIA | B A Transfer for Exp | | | 30000 | | ₹ 187,814.58 |
---|
12 | 17-Apr-2024 | STATE BANK OF INDIA | Cash Withdrawal - Exp | | | | 15000 | ₹ 172,814.58 |
---|
13 | 17-Apr-2024 | FEDERAL BANK | Payment for Rice | | 760 | | | ₹ 172,054.58 |
---|
14 | 22-Apr-2024 | STATE BANK OF INDIA | Cash Withdrawal | | | | 5000 | ₹ 167,054.58 |
---|
15 | 22-Apr-2024 | FEDERAL BANK | Cash Withdrawal | | 3000 | | | ₹ 164,054.58 |
---|
16 | 23-Apr-2024 | STATE BANK OF INDIA | STD CHART Card Payment | | | | 7306 | ₹ 156,748.58 |
---|
17 | 24-Apr-2024 | STATE BANK OF INDIA | Payment for Medicine | | | | 698.7 | ₹ 156,049.88 |
---|
18 | 27-Apr-2024 | STATE BANK OF INDIA | Cash Withdrawal | | | | 3000 | ₹ 153,049.88 |
---|
19 | 29-Apr-2024 | STATE BANK OF INDIA | Transfer to F B L | | | | 25000 | ₹ 128,049.88 |
---|
20 | 29-Apr-2024 | FEDERAL BANK | Transfer from S B I | 25000 | | | | ₹ 153,049.88 |
---|
21 | 30-Apr-2024 | FEDERAL BANK | Payment for Food | | 510 | | | ₹ 152,539.88 |
---|
22 | 30-Apr-2024 | FEDERAL BANK | Payment for Cake | | 630 | | | ₹ 151,909.88 |
---|
23 | 01-May-2024 | STATE BANK OF INDIA | Cash Withdrawal | | | | 2000 | ₹ 149,909.88 |
---|
24 | 01-May-2024 | STATE BANK OF INDIA | SBI Card Payment | | | | 2376 | ₹ 147,533.88 |
---|
25 | 02-May-2024 | STATE BANK OF INDIA | HDFC Card Payment | | | | 5041 | ₹ 142,492.88 |
---|
26 | 02-May-2024 | FEDERAL BANK | Payment for A H | | 3400 | | | ₹ 139,092.88 |
---|
27 | 06-May-2024 | STATE BANK OF INDIA | Payment for Medicine | | | | 735.78 | ₹ 138,357.10 |
---|
28 | 08-May-2024 | FEDERAL BANK | ICICI Card payment | | 13862 | | | ₹ 124,495.10 |
---|
29 | 14-May-2024 | STATE BANK OF INDIA | Salary | | | 35000 | | ₹ 159,495.10 |
---|
30 | 17-May-2024 | FEDERAL BANK | Payment for Software | | 2500 | | | ₹ 156,995.10 |
---|
31 | 22-May-2024 | STATE BANK OF INDIA | STD CHART Card Payment | | | | 11211 | ₹ 145,784.10 |
---|
32 | 24-May-2024 | FEDERAL BANK | Payment for Sweets | | 360 | | | ₹ 145,424.10 |
---|
33 | 25-May-2024 | STATE BANK OF INDIA | Cash Withdrawal | | | | 2000 | ₹ 143,424.10 |
---|
34 | 25-May-2024 | FEDERAL BANK | Temple Expenses | | 1120 | | | ₹ 142,304.10 |
---|
35 | 29-May-2024 | STATE BANK OF INDIA | Cash Withdrawal | | | | 2000 | ₹ 140,304.10 |
---|
36 | 31-May-2024 | STATE BANK OF INDIA | SBI Card Payment | | | | 225 | ₹ 140,079.10 |
---|
37 | 01-Jun-2024 | STATE BANK OF INDIA | HDFC Card Payment | | | | 4176 | ₹ 135,903.10 |
---|
38 | 03-Jun-2024 | FEDERAL BANK | Cash Withdrawal | | 2000 | | | ₹ 133,903.10 |
---|
39 | 05-Jun-2024 | STATE BANK OF INDIA | Salary | | | 35000 | | ₹ 168,903.10 |
---|
40 | 05-Jun-2024 | STATE BANK OF INDIA | Transfer to F B L | | | | 35000 | ₹ 133,903.10 |
---|
41 | 05-Jun-2024 | FEDERAL BANK | Transfer from S B I | 35000 | | | | ₹ 168,903.10 |
---|
42 | 06-Jun-2024 | STATE BANK OF INDIA | ICICI Card payment | | | | 4360 | ₹ 164,543.10 |
---|
43 | 10-Jun-2024 | FEDERAL BANK | Payment for Medicine | | 926 | | | ₹ 163,617.10 |
---|
44 | 12-Jun-2024 | STATE BANK OF INDIA | Transfer from BA for Exp | | | 38000 | | ₹ 201,617.10 |
---|
45 | 12-Jun-2024 | STATE BANK OF INDIA | Cash Withdrawal - Exp | | | | 20000 | ₹ 181,617.10 |
---|
46 | 13-Jun-2024 | STATE BANK OF INDIA | Gas Refund | | | 19.57 | | ₹ 181,636.67 |
---|
47 | 13-Jun-2024 | STATE BANK OF INDIA | Cash Withdrawal - Exp | | | | 18000 | ₹ 163,636.67 |
---|
48 | 15-Jun-2024 | STATE BANK OF INDIA | Cash Withdrawal | | | | 4000 | ₹ 159,636.67 |
---|
49 | 15-Jun-2024 | FEDERAL BANK | Cash Withdrawal | | 5000 | | | ₹ 154,636.67 |
---|
50 | 17-Jun-2024 | FEDERAL BANK | Cash Withdrawal | | 4000 | | | ₹ 150,636.67 |
---|
51 | 20-Jun-2024 | FEDERAL BANK | Payment to Oil | | 360 | | | ₹ 150,276.67 |
---|
52 | 21-Jun-2024 | STATE BANK OF INDIA | Transfer from BA for Exp | | | 15000 | | ₹ 165,276.67 |
---|
53 | 23-Jun-2024 | STATE BANK OF INDIA | Cash Withdrawal - Exp | | | | 5000 | ₹ 160,276.67 |
---|
54 | 25-Jun-2024 | STATE BANK OF INDIA | Intrest Credit | | | 385 | | ₹ 160,661.67 |
---|
|
---|