Excel: Conditional Formatting Not Applying with Mixed Data Types in Office 365
I'm working through a tutorial and I'm relatively new to this, so bear with me. I'm trying to configure I'm having trouble applying conditional formatting to a range of cells in Excel (Office 365). I have a column that contains a mix of numeric values and text strings. I want to highlight cells that are greater than 100, but it seems that conditional formatting is not behaving as expected. When I set the rule using the formula `=A1>100`, it doesn't seem to apply to the numeric values, and I suspect it might be because of the text entries in the same column. I've tried selecting the entire range and applying the formatting, but the cells with numeric values are being ignored. Here's the exact setup I have: - Column A contains values like 150, 'Test', 200, 'Sample', and 50. - I selected the range A1:A10 for applying the conditional formatting. - The formula I used in the conditional formatting rule is `=A1>100` and set the format to fill the cell with a red background. After applying the rule, only the cells containing numeric values seem to be evaluated, and the text cells are not highlighted at all, even though I want them to be ignored in the evaluation. I also checked the formatting options for numbers and confirmed they are set correctly. Is there a specific way to handle mixed data types for conditional formatting? Is there a workaround to ensure that only numeric cells are evaluated while ignoring text? Any insights or best practices would be greatly appreciated! I'm working on a API that needs to handle this. I'd really appreciate any guidance on this. What are your experiences with this? This is my first time working with Excel latest. Thanks for any help you can provide! Any ideas how to fix this?