hi to all
is this possible in the attached chart?
IF values G>value C column G turns red
max
hi to all
is this possible in the attached chart?
IF values G>value C column G turns red
max
I don't know if you can just change 1 without VBA. You can change a series if it is a negative value.
Anyway here is a vba solution
Please Login or Register to view this content.
Is this close enough?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi daves excel,
your macro how to apply it to the chart?
Dim error
Please Login or Register to view this content.
Last edited by max_max; 12-08-2019 at 08:30 AM.
If you need to dim x just "dim x" would work. x is not a range.
Were you able to check out Glen's solution?
The glen solution does not seem right to me.
Only column G if greater than C must be colored red.
Your solution, daves if there are more charts it works on all. It should only work on columns that are larger
Last edited by max_max; 12-08-2019 at 09:27 AM.
You didn't say that clearly...
"Only column G if greater than C must be colored red"
See post#7
You didn't say that clearly...
"Only column G if greater than C must be colored red"
Try it now (adjust values in green shaded row).
The colum G it becomes red only if greater.
And for new rows added?
You never mentioned extra rows until now...
One tiny tweak and then... this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks