Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have status field with values
status
Exams1
Exams2
Information1
Information2
i want to give green color which starts with Exams and i have to give black color value start with information
how to do that in my pivot table background color
Exams* as Green()
Inf* as Black()
Try this
if(Left(status, 5) = 'Exams', RGB(0, 255, 0),
if(Left(status, 10) = 'Information', RGB(0, 0, 0)))
Or
if(Match(Left(status, 5), 'Exams*'), RGB(0, 255, 0),
if(Match(Left(status, 3), 'Inf*'), RGB(0, 0, 0))
)
Try this
if(Left(status, 5) = 'Exams', RGB(0, 255, 0),
if(Left(status, 10) = 'Information', RGB(0, 0, 0)))
Or
if(Match(Left(status, 5), 'Exams*'), RGB(0, 255, 0),
if(Match(Left(status, 3), 'Inf*'), RGB(0, 0, 0))
)