Conditional formatting from another cell by range
Solved/Closed
riboss
Posts
1
Registration date
Thursday February 13, 2014
Status
Member
Last seen
February 13, 2014
-
Feb 13, 2014 at 07:13 AM
Blocked Profile - Feb 13, 2014 at 09:42 AM
Blocked Profile - Feb 13, 2014 at 09:42 AM
Hey,
I need helpppppppp
i want to change the color of a cell based on the range value of another cell
eg. i need a1 to be red if b1 is < 70%, Yellow if b1 is > 70% but < 85 and green if b1 is >85%
anyone?
thanks
I need helpppppppp
i want to change the color of a cell based on the range value of another cell
eg. i need a1 to be red if b1 is < 70%, Yellow if b1 is > 70% but < 85 and green if b1 is >85%
anyone?
thanks
Related:
- Conditional formatting from another cell by range
- Clear only the formatting from the selected cell (leaving the content) - Guide
- How to increase wifi range from router settings - Guide
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- If a cell has text then return value ✓ - Excel Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
