Hello,
Can anyone help me create a formula to create conditional formatting symbols in column E of my example. Doesn't have to be those triangles,,just anything to show positive or negative change. I don't know how to create those using a formula to look at what's in column D.
Thanks,
example.xlsx
hi SEMMatt. 1 of the ways is this. create a formula in E2 as such:
=CHOOSE(SIGN(D2)+2,CHAR(234),"",CHAR(233))
don't know what you want for 0%, so i left it blank. i listed a series of symbols you can use in column M. these are just for font type Wingdings. after using the formula, i formatted column E's font to Wingdings.
i then use condition formatting. select the range you want to apply to (i.e. E2:E8)
go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula
=$D2>0
format font colour as green
repeat the steps for negative, but with this formula:
=$D2<0
format font colour as red
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
See the attached
wow that's great! thank you.
thank you for that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks