Conditional Formatting based on percent of another cell.

[Dmajure]

Need help with conditional formatting, highlighting based on another cell, but not a simple "greater than"

Column A is greater than 75% of column B

A	B
6	20
33 (red)	42
15 (red)	17
1	16

 

[Joe4]

Welcome to the Board!

Let's say that you were applying to it cell A2.
Then select cell A2, go to Conditional Formatting, choose the "Formula" option (the last one), and use this formula:

=A2>(B2*.75)

and choose your red formatting color.

To apply it to a whole range of cells at once, select the whole range, and then write the formula as it pertains to the first cell in your selection, and Excel will automatically adjust it for the other cells.

 

[etaf]

=($A2/$B2)>0.75
As a conditional formatting rule

Book1
	A	B	C	D
1	A	B
2	6	20		30%
3	33	42	red	79%
4	15	17	red	88%
5	1	16		6%
Sheet2

Cell Formulas
Range	Formula
D2:D5	D2	=A2/B2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:A5	Expression	=$A1/$B1>0.75	text	NO

 

[Dmajure]

Thank You! I'm Probably going to have many future questions too ?

 

[Joe4]

You are welcome.
Glad we were able to help.