Conditional formatting using formula to always round up a number

[CoryCrandall]

I have a column of Currency values, but I want the values to always round up to the next whole number. I don't want to have to enter a formula for each cell, since it is meant to be a quick entry.

Example of what is entered into a cell	What I would like to see visible
10.10	$11
10.21	$11
10.69	$11
10.82	$11
=10.11+10.30	$21

I've been trying to figure out how to apply the ROUNDUP or CEILING formula across a whole column, but I cannot seem to find a way (if there is a way) to have the value of the cell as a variable in the formula. Any ideas if there is a way to always round up, conditional formatting or otherwise?

 

[arthurbr]

Be aware that formatting DOES NOT affect the underlying value, it only changes what you see. (
Why not make your range an Excel Table, use a formula in the first row for rounding (ROUNDUP,...). After that when you add data in the following rows, the formula will extend to the new rows, nothing to do.