cancel
Showing results for
Did you mean:
New Member

## Conditional formatting based on a comparison of two numbers

Hello everyone,

I have a question about Conditional Formatting and would really appreciate if someone could help me.

Initial situation:
I have a matrix with three columns:
1. event type
2. total number of events (of the type) that have already taken place
3. total number of events (of the type) that should be reached

Question: Is there a way to color-code the actual numbers, for example red if they do not yet meet the target numbers and green if the targeted total number has already been reached ?

Thanks a lot 🙂

1 ACCEPTED SOLUTION
Community Champion

@LLuet
Try to add a measure to find the meet target status and then use that to set up the conditional formatting.

measure would be something like this:

measure=
Var _Variance = if([type] = A, [No. taken place]-39,[No. taken place]-8)
\\to find the variance between the actual vs forecast
return
if(_Variance>=0,True(),False()
\\ if _variance equal or bigger that 0, it means target has been met

4 REPLIES 4
New Member

First of all, thanks for the quick answers, but the correct solution was probably not there yet.

I understand how normal conditional formatting works, but in my case I can't specify a threshold. To clarify the problem, here is a short example:

Event type A has taken place 23 times, but is supposed to take place 39 times. Event type B has taken place 15 times, although only 8 were planned.

Since the threshold value is different, I cannot specify a certain number from which a condition was met or not met. The numbers for each event type must be compared individually.

Community Champion

@LLuet
Try to add a measure to find the meet target status and then use that to set up the conditional formatting.

measure would be something like this:

measure=
Var _Variance = if([type] = A, [No. taken place]-39,[No. taken place]-8)
\\to find the variance between the actual vs forecast
return
if(_Variance>=0,True(),False()
\\ if _variance equal or bigger that 0, it means target has been met

Community Champion
Helper V

you can use conditional formating background color upon threshold

Announcements

#### Launching new user group features

Learn how to create your own user groups today!