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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies