Conditional Formating

[thewardn]

I am trying to make a true or false reference column. IF column Ab's value is (ab>=15 but <30) equal true if not leave blank if possible or false if not possible.

 

[Cubist]

Select the cells -> Use formula to determine rule -> Insert:

=AND(AB7>=15,AB7<30)

 

[thewardn]

Select the cells -> Use formula to determine rule -> Insert:

=AND(AB7>=15,AB7<30)

All Values return as false except 20=true. This is the problem i was having with nothing working. Column AB is formatted as number but references graph column in H (column13). I wish i could download XL2bb but cant at work.

 

[thewardn]

View attachment 121497
All Values return as false except 20=true. This is the problem i was having with nothing working. Column AB is formatted as number but references graph column in H (column13). I wish i could download XL2bb but cant at work.

column 8 not 13 srry

 

[Cubist]

Your "numerical" columns are aligned left suggest that they're text and not number. Changing the format doesn't change how Excel stores that variable type. See this site - how to convert them to number.

Excel: convert text to number with formula and other ways

The tutorial shows how to change text to number by using Excel's Convert to Number error checking option, formulas, mathematic operations, Paste Special, and other ways.

www.ablebits.com

 

[thewardn]

Your "numerical" columns are aligned left suggest that they're text and not number. Changing the format doesn't change how

TY this helped. when pasted from graph it showed number but needed to =value for import

 

[thewardn]

done