Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
JoseGarcia
Creator III
Creator III

Color cell formatting

Hi there, 

Looking to colour format a table.

Color format, reads if field KPI_Baseline greater than field KPI_result, red colour, otherwise green.

Formula:
If(sum(KPI_baseline)>(KPI_result), RGB(255,0,0), RGB(0,255,0))

seems to go round in circles. 
Could anyone help?

Thanks a million.

Jose

Labels (1)
1 Solution

Accepted Solutions
JustinDallas
Specialist III
Specialist III

What do you mean "Seems to go round in circles"?

View solution in original post

2 Replies
JustinDallas
Specialist III
Specialist III

What do you mean "Seems to go round in circles"?

JoseGarcia
Creator III
Creator III
Author

formula is giving me error