Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

trend arrow up down

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Trend arrow up down

Trend arrow up down

ResolvedVersion 2016

Dimple has attended:
Excel Intermediate course

Trend arrow up down

hi there
i am making a risk register and want to be able to use arrows showing whether the trend is going up or down since last time (manual arrow rather than automated), how do I do this without doing something old fashioned like drawing an arrow from word and coping over ?

RE: trend arrow up down

Hi Dimple

I would try a few options using conditional formatting

You could use a custom rule identifying if cell A2 is larger than B2. If it is, make it green, if not change it to red.

OR

You could add a separate column with a calculation that determines whether you've had an increase or decrease in totals and then create a condition to match.

I have attached a file that should give you an idea of the different options available.

Please let me know if you need any assistance recreating the conditions

Kind regards
Wendy

Attached files...

conditional formatting.xlsx

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Tue 12 Dec 2017: Automatically marked as resolved.

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.16 secs.