PDA

View Full Version : Solved: Conditional Formatting for Numbers Only



U_Shrestha
07-07-2008, 02:24 PM
Hi all,

Column AB2:E100 might have the values in numbers or texts; how can I automatically have red fonts if the value is a number instead of text? Numbers can be 1, 1.5, 5.75, 21 etc, texts can be "ND", "NS" etc.

figment
07-07-2008, 02:53 PM
in the conditionalformatting window for AB2 put the formula =if(isnumber(AB2),true,false) then copy and paste special formats through the rest of your range.

Bob Phillips
07-07-2008, 04:03 PM
in the conditionalformatting window for AB2 put the formula =if(isnumber(AB2),true,false) then copy and paste special formats through the rest of your range.

You can simply use

=ISNUMBER(AB2)

U_Shrestha
07-08-2008, 05:27 AM
It worked, thank you both :thumb