Forum Discussion
Excel 365 Conditional Formatting Data Bar
I have 2 cells (K50 & G30). I want to display a CF Data Bar in G30 according to the increasing value of K50 (which is already set to do so). How do I accomplish this? Everything that I have tried, so...
SergeiBaklanThank you for your explanation. For G38 I saw and set the min & max values according to the value of K50 (between 0 - 50 (in increments of 10)), which should have forced it to work. In my lack of understanding of Data Bars, I abandoned this idea entirely and just used an IF stament for G38 (in CF, of course) that when K50 reachs max value to simply change color, which is almost just as good. Again, I thank you for your kindness in replying.
dlcartin , thank you for the update. As a comment, in CF you usually may avoid using of IF() in form of =IF(condition, TRUE, FALSE). The form =condition works exactly the same way.