March 1, 2012 at 4:34 am
Hi everyone
I have a report that contains a SWITCh function which changes the background colour of the report cells using the RAG color coding depending on the total contained in the cell. What i would like to do is change the font to white if the result is red or green but black if the result is yellow so the figures are easier to see.
I'm guessing I'd need to use another SWITCH function but need pointers as to where.
Any help greatly appreciated.
BO
March 1, 2012 at 6:31 am
This is the way I would do it. Your font color switch would use the same data points as the background.
Say your switch function for the background color looks like this
=Switch(
Fields!PctComplete.Value >= 10, "Green",
Fields!PctComplete.Value >= 1, "Amber",
Fields!PctComplete.Value <= 0, "Red")
Your font color expression would be very similar
=Switch(
Fields!PctComplete.Value >= 10, "white",
Fields!PctComplete.Value >= 1, "black",
Fields!PctComplete.Value <= 0, "white")
I like the idea of your font expression checking the background color and making a smart decision on the color is uses, just don't know how to get there. That is the reason for doing it the way I did.
March 1, 2012 at 7:39 am
Cheers Calvo - that's perfect for my needs.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply