IF THEN Conditional Formatting

[TKC100]

I am certain the answer to my questions is simple for you all but it has me stumped.
I have a column (A) of numbers both positive and negative.
If the value of any number is column A is more than 10 (absolute value +or -) color the cell red.
I don't know it the formula should be for A1 and then just copy and paste for the remainder of the column or what.
In plain English I need to know if the value of any cell within a column exceeds the value of 10 weather it is a positive or negative number by coloring the cell red.
If you all could assist me with this I would be very grateful.
Thanks!

 

[dreid1011]

Yes, it should be pretty simple, something like this:

Book1
	A
1	4
2	-4
3	13
4	1
5	4
6	14
7	-15
8	-4
9	10
10	1
11	9
12	-15
13	-12
14	-3
15	-10
16	-7
17	12
18	15
19	7
20	9
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A20	Expression	=ABS(A1)>10	text	NO

Select the range you want it to apply to and use the CF formula above.

 

[TKC100]

Thanks for the reply
OK now I get to show off how much I don't know.
How do I enter the suggested formula? I am only familiar with entering formulas in a cell or within the formula bar.
When I go to Styles > conditional formatting I can not find anything that resembles your suggestion. (Microsoft 365)
The first row of my sheet is a header and I am wanting to conditionally format E2 - E141

 

[dreid1011]

Sure, after selecting your desired range in column E (E2:E141), on the home ribbon, go to Conditional Formatting:

Select New Rule:

Select Use a formula to determine which cells to format, enter the formula I provided above into the formula bar "=ABS(E2)>10" (without the double quotes), then select format to choose your formatting:

Then select Ok.

 

[TKC100]

Thanks again

 

[TKC100]

Perhaps you could assist me in yet another problem.
E2 -1.5 E3 2.3 E4=3.8
How do I write a formula to express the distance between these two numbers
-1.5 to 0 = 1.5 and 2.3 to 0 = 2.3 The answer I need is 3.8
Simple addition or subtraction does not work.
The data collected in both columns (E2 E3) could have negative or positive values. For my purpose I need to know the distance between the two number (columns)
I can do the arithmetic easy enough but not for 100+ cells
I assume the formula would be written within cell F4. Can F4 then have conditional formatting as you previously explained in addition to the existing formula?

I am grateful for your help. It all seems, and when you how to do it, so simple.

 

[dreid1011]

Normally as this is a completely different problem, you should create a new thread. However, it is also rather simple and you can achieve the desired result using the absolute value function ABS().

Book1
	E
2	-1.5
3	2.3
4	3.8
Sheet5

Cell Formulas
Range	Formula
E4	E4	=ABS(E2)+ABS(E3)

 

[TKC100]

Thank you!
I considered starting a new thread because I have seen subjects get completely off topic before. Pretty soon the discussion devolves into your favorite beer.

 

[dreid1011]

You're welcome, and happy to help.