Conditional Formatting

[jhow659]

Is it possible to us conditional formatting to tell excel "if a cell in range A1:A10=number then format the cell next to it in column B if that number is not a number 1-10?"

For example:
A1= 10
A2= 1
A3= 9
A4=5
A5=6
A6=4
A7=7
A8=3
A9=8
A10=2

B1= 1
B2= 15
B3= 2
B4= 3
B5= 4
B6= 16
B7= 5
B8= 6
B9= 7
B10= 8

I want to ask if 2 is in a cell from A1:A10 then if it is the cell next to it in column B if it isn't between 1 & 10 then Highlight it red.

 

[jtakw]

Hi,

Assuming you won't have negative numbers, try:

=AND(ISNUMBER(A1),B1>10)

Select the range you want Conditional Formatted, use formula to format cells...