Conditional formatting & decimal part of a number in cell

  • Thread starter Thread starter Mac
  • Start date Start date
M

Mac

Hello all,

in a conditional formatting scenario, which function do I use to decide if
the decimal part of the number in a cell is zero (i.e. x.0 and not x.1, x.2,
....)?
 
Uh oh, this does not seem to work; my numbers are either x.5 or x.0; I need
my x.0's get formatted and all x.5's left as they are. Might the decimal
format be the problem for MOD function?
 
David, the conditons you mentioned were all positive but th eproblem was -
for some reason, after having entered my condition formula and reopening the
Conditional Formatting dialog, the formula was surrounded by commas; deleted
those, saved, now it works great. Thanky you!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Decimal fractions to binary and vice versa 1
Nested If statement to control format of number-type cells 3
Conditional Formatting from a group 6
Trim varying decimals from column of numbers 9
Conditional Formatting 1
Conditional Cell Formatting 5
Hiding certain decimal values 4
Conditional Formatting Formula Not Working 1

Back
Top