DarrenBurke
New Member
- Joined
- May 6, 2022
- Messages
- 29
- Office Version
- 2016
- 2007
- Platform
- Windows
Good Morning All.
I have this sheet, Fundraisers, I am trying to give a cost of making the snack hamper.
I have applied conditional formatting to coloum J to only show Snack hampers , i have conditional formatted other text using 3 semi colon in format ;;; this hides the contents of the cells that dont have snack hampers
I have a sheet called Data. ( I use for creating dropdown list) In the sheet i have a named range called "SnaHamp" all the different types of snack hampers are in the named range
The range of hampers all cost 300 to make, these are then sent to customers that have made a donation to our care centre for abused women and children as a Thank You.
What i am try to do ... If coloum J6 to J144 contains text for the hampers (named range is SnaHamp) then K6 to K144 should return a cost to make this of "300"
Attached is a small l2bb and a snapshot of the named range on my Data sheet
I hope its a clear enough description
Thank you and God bless
I have this sheet, Fundraisers, I am trying to give a cost of making the snack hamper.
I have applied conditional formatting to coloum J to only show Snack hampers , i have conditional formatted other text using 3 semi colon in format ;;; this hides the contents of the cells that dont have snack hampers
I have a sheet called Data. ( I use for creating dropdown list) In the sheet i have a named range called "SnaHamp" all the different types of snack hampers are in the named range
The range of hampers all cost 300 to make, these are then sent to customers that have made a donation to our care centre for abused women and children as a Thank You.
What i am try to do ... If coloum J6 to J144 contains text for the hampers (named range is SnaHamp) then K6 to K144 should return a cost to make this of "300"
Attached is a small l2bb and a snapshot of the named range on my Data sheet
I hope its a clear enough description
Thank you and God bless
GetdatafromFundRaisers1.xlsm | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | |||
5 | DATE | REF | NO | CANVASSED | COLLECTED | COMM | BTF | CUSTOMER | HAMPER | H/Cost | ||
6 | 07-Jul | MF | 355 | ZAMBESI GLASS&ALUMINIUM | ||||||||
7 | 06-Jul | MF | 354 | R 550,00 | R 550,00 | R 550,00 | CASH | JMR TRANSPORT SOLUTIONS(PTY)LTD | ||||
8 | 06-Jul | MF | 351 | R 200,00 | R 200,00 | R 200,00 | CASH | GRAYTEX METALS | ||||
9 | 06-Jul | MF | 352 | R 100,00 | R 100,00 | R 100,00 | CASH | CAR CLINIC | ||||
10 | 06-Jul | MF | 353 | R 550,00 | R 550,00 | R 550,00 | CASH | B&R MOTOR ENGINEERING | ||||
11 | 05-Jul | MF | 344 | R 550,00 | R 550,00 | R 550,00 | CASH | TOTAL CAMPBELLS | ||||
12 | 05-Jul | MF | 350 | CASH | AUDREY PETZER | FOOD PARCELL | ||||||
13 | 04-Jul | MF | 349 | R 100,00 | R 100,00 | R 100,00 | CASH | CARLOS DA COSTA | ||||
14 | 04-Jul | MF | 345 | R 200,00 | R 200,00 | R 200,00 | CASH | LANDYTECH | ||||
15 | 04-Jul | MF | 346 | R 200,00 | R 200,00 | R 200,00 | CASH | BUSSINES EXPRESS | ||||
16 | 28-Jun | MF | 333 | R 500,00 | R 500,00 | R 500,00 | CASH | MUGG AND BEAN | ||||
17 | 28-Jun | MF | 334 | R 100,00 | R 100,00 | R 100,00 | CASH | M & M HYDRAULICS CC | ||||
18 | 23-Jun | MF | 328 | R 1 000,00 | R 1 000,00 | R 1 000,00 | CASH | LINDSAY SAKER VW ALBERTON | BILTONG /RED WINE | |||
19 | 22-Jun | MF | 324 | R 200,00 | R 200,00 | R 200,00 | CASH | DP WOODWORKS | ||||
20 | 22-Jun | MF | 325 | R 400,00 | R 400,00 | R 400,00 | CASH | MAINLY GOLF (PTY) LTD | ||||
21 | 22-Jun | MF | 326 | R 1 000,00 | R 1 000,00 | R 1 000,00 | EFT | FEDERAL CLEARING&FORWARDING COMPANY | BILTONG/FRUIT JUICE | |||
22 | 22-Jun | MF | 327 | R 600,00 | R 600,00 | R 600,00 | WIMPY ARCON PARK | |||||
23 | 22-Jun | MF | 321 | R 100,00 | R 100,00 | R 100,00 | CASH | ATTACK GLAS WERKE | ||||
24 | 22-Jun | MF | 322 | R 600,00 | R 600,00 | R 600,00 | CASH | NOBLE MOTOR AND CONTROL | ||||
25 | 22-Jun | MF | 323 | R 600,00 | R 600,00 | R 600,00 | CASH | JMR TRANSPORT SOLUTIONS(PTY)LTD | BILTONG/WINE | |||
26 | 21-Jun | MF | 1 | R 200,00 | R 200,00 | R 200,00 | EFT | NORTH LAWNMOWERS | ||||
27 | 21-Jun | MF | 1 | R 500,00 | R 500,00 | R 500,00 | EFT | MARK MELTZER | ||||
28 | 15-Jun | MF | 286 | R 200,00 | R 200,00 | R 200,00 | CASH | WAYNE ROUX | ||||
29 | 14-Jun | MF | 1 | FAME FENCE(PTY)LTD | ||||||||
30 | 14-Jun | MF | 318 | R 200,00 | R 200,00 | R 200,00 | CASH | NORTH LAWNMOWERS | ||||
31 | 13-Jun | MF | 316 | R 200,00 | R 200,00 | R 200,00 | CASH | ROSE LIEBENBERG | ||||
32 | 13-Jun | MF | 314 | R 200,00 | R 200,00 | R 200,00 | CASH | SCOTSMAN ICE SYSTEMS | ||||
33 | 08-Jun | MF | 301 | R 200,00 | R 200,00 | R 200,00 | CASH | LUV MOR MUSIC | ||||
34 | 08-Jun | MF | 303 | R 200,00 | R 200,00 | R 200,00 | CASH | IRENE SAUNDERS | ||||
35 | 08-Jun | MF | 304 | R 100,00 | R 100,00 | R 100,00 | CASH | LYNS PRE-SCHOOL | ||||
36 | 07-Jun | MF | 299 | R 400,00 | R 400,00 | R 400,00 | CASH | GRAYTEX METALS | ||||
37 | 07-Jun | MF | 296 | R 400,00 | R 400,00 | R 400,00 | CASH | JMR TRAILERPARTS GAUTENG(PTY)LTD | ||||
38 | 07-Jun | MF | 297 | R 400,00 | R 400,00 | R 400,00 | CASH | ISA VAN SCHALKWYK | ||||
39 | 07-Jun | MF | 298 | R 4 800,00 | R 4 800,00 | R 4 800,00 | EFT | ALMECH PTY LTD | ||||
40 | 02-Jun | MF | 287 | R 500,00 | R 500,00 | R 500,00 | CASH | SCOTSMAN ICE SYSTEMS | ||||
41 | 01-Jun | MF | 292 | R 100,00 | R 100,00 | R 100,00 | CASH | CAR CLINIC | ||||
42 | 31-May | MF | 288 | R 550,00 | R 550,00 | R 550,00 | EFT | MARK MELTZER | SNACK FRUIT JUICE | |||
43 | 31-May | MF | 289 | R 500,00 | R 500,00 | R 500,00 | EFT | AUTOBAR | ||||
SalaryData |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
K6:K144 | Cell Value | contains "" | text | NO |
D6:D144 | Cell Value | duplicates | text | NO |
D6:D144 | Cell Value | duplicates | text | NO |
J6:J144 | Cell Value | contains "TA" | text | NO |
J6:J144 | Cell Value | contains "THANK YOU LETTER" | text | NO |
J6:J144 | Cell Value | contains "DELIVER HAVEN DOCS" | text | NO |
J6:J144 | Cell Value | contains "24X TICKETS" | text | NO |
J6:J144 | Cell Value | contains "2X TICKETS" | text | NO |
J6:J144 | Cell Value | contains "RAFFLE TICKET" | text | NO |
J6:J144 | Cell Value | contains "TAX" | text | NO |
J6:J144 | Cell Value | contains "TAX INVOICE" | text | NO |
H6:H144 | Cell Value | contains "BTF" | text | NO |
H6:H144 | Cell Value | contains "BTF" | text | NO |
H6:H144 | Cell Value | contains "EFT" | text | NO |
E6:G144 | Cell Value | contains "0.00" | text | NO |