Hello World,
I need formula to format cell(custm type) B3 , if cell A3=Diesel
B3=40 (if A3=Diesel, B3=40L )
Can anybody help me please? and sorry for bad english
Hello World,
I need formula to format cell(custm type) B3 , if cell A3=Diesel
B3=40 (if A3=Diesel, B3=40L )
Can anybody help me please? and sorry for bad english
Formula:Please Login or Register to view this content.
If this works for you then mark this thread as Solved ( See at top "Thread Tools")
"Add reputation" to answer if anyone helps you in this forum...
Last edited by mangesh.mehendale; 10-13-2015 at 12:42 AM.
Don`t care, take care...
Regards,
Mangesh
Not sure I fully understand what you want here
Do you want to change the appearance (the format, eg color, font etc) of the cell, depending on another cell
Or do you want the cell to display a certain answer, depending on the contents of another cell?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yes I want to change format depending on other cell.
mangesh.mehendale thanks for the reply, but as next step I will need to calculate result, your option wont help me.
I have product list on cell A and amount of products on cell B
I need formula to show amount as Litre (##### "L") on B3 if only A3=Diesel
and cell C will calclulate product total
If I understand you correctly, if A3 is 'Diesel' you want the number in B3 to be followed by 'L' and if A3 is anything else, you want it just to be a number?
If that's correct, then do this:- Select B3 and click 'Conditional Formatting' on the 'Home' tab.
- Select 'New Rule' then 'Use a formula to determine which cells to format'.
- In the formula box, type =A3="Diesel" then click the 'Format' button.
- Select the 'Number' tab, then click 'Custom' at the bottom of the list on the left-hand side. In the 'Type' box on the right, type this: 0" L"
If you need to copy this formatting to other cells, click B3 then click 'Format Painter' (beside the 'Paste' button on the 'Home' tab) and then click the other cells you want formatted the same way.
If it's always column A you need to refer to, you will need to change the Conditional Formatting formula above to use $A3 - if it's always row 3, then use A$3 - if it's always cell A3, then use $A$3 (look up 'relative and absolute cell references' in a search engine if that doesn't make sense).
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
@ Aardigspook
@ FDibbins
Hello Experts here is one idea to this but due to lack of deep knowledge I am not able to tackle.. We can do this with Event + Macro... see attached sheet entering "Diesel" in A6
finally ... (updated for use of other people with same query )
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks