I want to change the background colour of cells based on if they contain just integers. Can I do this?
Answered here
Summary:
In the Conditional Formatting dialogue, you can select between All Cells, Cell Value is, Formula is, and Date is.
If you select Formula is and =Int(A1)=A1, then apply the formatting you want, in my case a green background, that will do the trick.