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

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,

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?

Hi,

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

Look at the second sheet.

Good luck

View attachment Copy - updated 2.xlsm