Results 1 to 3 of 3

Thread: Conditional Formatting in cell or column, contained in a table in the sheet

  1. #1

    Conditional Formatting in cell or column, contained in a table in the sheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I am trying to apply conditional formatting to a cell,(containing numbers greater than or equal to million- the 'M' number format) in the table present within the sheet.
    I am able to create a new rule, and upon clicking 'Apply' , the rule is created. But it is not getting applied on the selected cell, or the entire column.

    Attached is the excel I am trying to apply conditional formatting. I am trying to apply the conditional formatting on cells like B2, B4, B5.




    Please help!! Urgent!!



    Thanks,
    Attached Files Attached Files

  2. #2
    Acolyte Ron Coderre's Avatar
    Join Date
    Aug 2015
    Location
    Boston, MA
    Posts
    93
    Articles
    0
    Excel Version
    2013, 2016, O365
    You have the worksheet set to display formulas...not their values.
    Try this on the ribbon:
    • Formulas.Show_Formulas

    Now the conditional formatting can be displayed.

    Does that help?
    Ron Coderre
    Former Microsoft MVP (2006-2015)

  3. #3
    Conjurer hossat's Avatar
    Join Date
    May 2015
    Location
    Algiers, Algeria
    Posts
    102
    Articles
    0
    Excel Version
    365
    Hi,

    I think that you have to format your column into number. They look like text format.

    Look at the second sheet.

    Good luck

    Copy - updated 2.xlsm

Tags for this Thread

Posting Permissions

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