Home

Conditional Formatting Formulas

Briana_Valeriano
New Contributor
In column A, I have 10 numbers. I want column B to have conditional formatting where if I enter a number that is higher than 70% of the value in column A, it will turn green. If it’s 70% or lower it will turn red.
3 Replies

You may apply to column B conditional formatting rule for the green with formula 

=$B1>0.7*$A1

assuming your range starts from first row. Similar for the red rule.

 

This works when I do it for just the first row but How do I apply that formula to all of column B. And not individually typing a formula for each cell in B

It works for your entire range

image.png

Please see attached

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies