Conditional formatting with two conditiions

[cajste]

Hi,

I've been asked to setup a conditional formatting with coloured arrows based on two criterias. The direction of the arrow is determined by the development from last month and the colour of the arrow is determined by the present value compared to a target. I've been playing around to solve this but haven't any solution so far. Anyone having a good solution?

Brgds,
Caj

 

[bertie]

I had a play around with this and came up with a solution using the up arrow (character 233) and down arrow (character 234) in the "Wingdings" font.

To test:
Open a new workbook.
Press Alt+F11 to open the vba editor window.
Click Insert => Module
Copy and paste the code.
Press F5 to run.
Edit the TEST and TARGET values and run again.

Option Explicit


Sub test()
   Dim targetValue As Long
   Dim testValue As Long
   
   targetValue = 10
   testValue = 5
   
   If testValue < targetValue Then
      With Sheets("Sheet1").Range("A1")
         .Value = Chr(234)          'down arrow
         .Font.Name = "Wingdings"
         .Font.Color = vbRed
      End With
   Else
      With Sheets("Sheet1").Range("A1")
         .Value = Chr(233)          'up arrow
         .Font.Name = "Wingdings"
         .Font.Color = vbGreen
      End With
   End If
   
End Sub

Hope this gives you some ideas,
Bertie

 

[cajste]

Thank's alot, will try it!

I came up with a similar solution, using the wingding font in a formula and conditional formatting to colour the arrows based on different thresholds for each KPI and month.

//Caj