+ Reply to Thread
Results 1 to 9 of 9

Formact Cell IF!

  1. #1
    Registered User
    Join Date
    09-08-2015
    Location
    Baku
    MS-Off Ver
    2016
    Posts
    38

    Formact Cell IF!

    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

  2. #2
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Formact Cell IF!

    Formula: copy to clipboard
    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

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Formact Cell IF!

    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

  4. #4
    Registered User
    Join Date
    09-08-2015
    Location
    Baku
    MS-Off Ver
    2016
    Posts
    38

    Re: Formact Cell IF!

    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.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Formact Cell IF!

    Quote Originally Posted by Akbaruu View Post
    Yes I want to change format depending on other cell.
    OK so help me understand what you want.

    Show me what you have, and then tell me what needs to change to what, based on what?

  6. #6
    Registered User
    Join Date
    09-08-2015
    Location
    Baku
    MS-Off Ver
    2016
    Posts
    38

    Re: Formact Cell IF!

    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

  7. #7
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: Formact Cell IF!

    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.

  8. #8
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Formact Cell IF!

    @ 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
    Attached Files Attached Files

  9. #9
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Formact Cell IF!

    finally ... (updated for use of other people with same query )

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] When one cell equals value of another cell, then third cell displays text of fourth cell?
    By spookymyo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-12-2021, 02:12 PM
  2. Replies: 0
    Last Post: 03-20-2014, 10:57 AM
  3. [SOLVED] Macro Delete Contents in 23rd corresponding cell if the cell in range is a non-blank cell
    By murtaza.khan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-04-2014, 01:11 AM
  4. If Cell A is equal to Cell B replace the data from Cell A with Cell C. How can I do this.
    By tristanhathaway in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-01-2014, 08:05 PM
  5. [SOLVED] How to create/run "cell A equals Cell B put Cell C info in Cell D
    By abmb161 in forum Excel General
    Replies: 7
    Last Post: 02-05-2014, 02:20 AM
  6. Replies: 1
    Last Post: 11-06-2013, 02:56 AM
  7. copy a cell multiple times depending on cell value starting on a specific cell
    By weritadiojomiel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2013, 05:25 AM
  8. Replies: 1
    Last Post: 11-03-2012, 09:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1