Number Format Syntax

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What I want to do is format cell(s) so that if the value is less than 100, I
want the number in red. If it is 100 or greater, make black.

Thanks
 
It also needs to be in percentage

less than 100% Red, 100% or greater Black
 
Select your range of cells, click Ctrl+1, select Number
tab, click "Custom", and insert this to the right:

[Red][<1]0.00%;[Black][>=1]0.00%;General

HTH
Jason
Atlanta, GA
 
[Red][<1]0%;0%

is one way

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Thank you very much guys!

Jason Morin said:
Select your range of cells, click Ctrl+1, select Number
tab, click "Custom", and insert this to the right:

[Red][<1]0.00%;[Black][>=1]0.00%;General

HTH
Jason
Atlanta, GA
-----Original Message-----
What I want to do is format cell(s) so that if the value is less than 100, I
want the number in red. If it is 100 or greater, make black.

Thanks
.
Click to expand...
Click to expand...
 
You must log in or register to reply here.

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

Excel Conditioning Formatting 3
Excel Need Countifs Formula Help 0
Color rows based on a cell value 2
Conditional format if difference in cell values greater than 0.50% 1
[Black]$#,##0.00;[Red]($#,##0.00);[Blue]$0.00 (CUSTOM FORMAT) 3
Arithmetic with Cell Dates 1
Simplifying an If(OR(…)) statement 6
Conditional formating question 2

Back
Top