Can I use different conditional formatting for different cells in the same spread sheet?
If yes, how can I do this. Thank you.
In a word yes!!
Try this video
Conditional formatting - highlight entire row based on a cell value
The below is from a thread call "Conditional Formatting Cells based on overlapping range": it could a good example of multiple criteria for conditional formatting.
Quote Originally Posted by BennyH View Post
Tried copying but still getting an error message for formula 1-amber? Maybe a picture describes it best, i want the cell formatting to come back with red if its> +/-10%, amber within 5% to 10% (over or under spent) & green if its within -5% to 5% of budget
:
Budget vs Actual Variance
<-10.1% -10% -5.1% -5% 0% 5% 5.1% 10% 10.1%>
Hi Benny, sorry about the late reply but actually had to do some work!! Shocking turn events.
I redid your project and got the results you needed!!
How I did it was with two formulas, but both using the same colors to achieve the results.
Five formulas were used, I will list them below, from smallest percentage to largest and then go through the steps I took
=$D2<-10.1% Color Red
=AND($D2<=-5%,$D2>=-10.1%) Color Yellow
=AND($D2>=-5%,$D2<5%) Color Green
=AND($D2>=5%,$D2<=10.1%) Color Yellow
=$D2>10.1% Color Red
Steps taken to achieve results.
1) Highlight cells A2 too D6
2) Click on Conditional Formatting, Manage Rules
3) Click on New Rule
4) Click on Use a Formula
5) Paste formulas in to box
6) Click on the format box and choose your color
7) Click OK twice and there you have it
Make sure you remove the second $ and you have the <=>signs in their correct place and that should do it!!
