NewsBot
1
Classic, im at an event this afternoon when the poop hits the fan. I need to do some quick formatting to an excel sheet.
So you use the new conditional formatting tool. You try making a simple if statement there. Doesnt work what so ever. For example, make a sheet, A1 = 1, A2 = 2, A3 = conditional formatting, make your own rule. If(A1>A2) set your format red. Wont do it. I understand the value isnt in the cell im trying to change, but why does that matter? If thats the case, dont let me make my own rule.
So im stuggling to get the colors. So I sort by val, sack it im in a rush, I need to get all Negative numbers green and positive red. So I have about 2000 values ranging from -£4,000 ish to +£1000 so I sort on the value and expand the selection. Why o why, does it not sort? Negatives are in with the positives and vice versa. Its quite close, but they are still mashed in together.
So conditional formatting you cant make your own rule, so why add that feature. If you sort on currency lowest to highest, it just doesn't sort correctly.
YES I could go in the code and code all of this nicely within half hour or so to get it perfect. But my point is you have given me the tools so that I dont have to do that. They dont work lol
More...
View All Our Microsoft Related Feeds
So you use the new conditional formatting tool. You try making a simple if statement there. Doesnt work what so ever. For example, make a sheet, A1 = 1, A2 = 2, A3 = conditional formatting, make your own rule. If(A1>A2) set your format red. Wont do it. I understand the value isnt in the cell im trying to change, but why does that matter? If thats the case, dont let me make my own rule.
So im stuggling to get the colors. So I sort by val, sack it im in a rush, I need to get all Negative numbers green and positive red. So I have about 2000 values ranging from -£4,000 ish to +£1000 so I sort on the value and expand the selection. Why o why, does it not sort? Negatives are in with the positives and vice versa. Its quite close, but they are still mashed in together.
So conditional formatting you cant make your own rule, so why add that feature. If you sort on currency lowest to highest, it just doesn't sort correctly.
YES I could go in the code and code all of this nicely within half hour or so to get it perfect. But my point is you have given me the tools so that I dont have to do that. They dont work lol
More...
View All Our Microsoft Related Feeds