Excel Guides

How to conditionally format non-integers in Excel

To conditionally format non-integers in Excel, you will need to use a custom formula. The formula will check to see if the cell value is not an integer, and if it is not, it will apply the desired formatting. Here is the formula:

=NOT(ISNUMBER(A1))

Replace "A1" with the cell reference that you want to check. This formula can be used for conditional formatting in Excel by selecting the cells that you want to format, going to the "Conditional Formatting" menu, selecting "New Rule", and then choosing "Use a formula to determine which cells to format". In the "Format values where this formula is true" field, enter the above formula.

You can then choose the desired formatting options, such as font color, fill color, or number format. Click "OK" to apply the conditional formatting.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.