Is there a way to switch text data on and off with a click box?
I have worked out how to drop the cell colour within the cell to only show the text, but I want to be able to only show the colour of the cell and not the text.
Is there a way to switch text data on and off with a click box?
I have worked out how to drop the cell colour within the cell to only show the text, but I want to be able to only show the colour of the cell and not the text.
1. Your green formula should be >= 20 not just > 20
If the value is 20 nothing will be set in CF.
2. Your CF conflicts with your data.
CF will only be set if there is a value in the cell.
But if you have a value in the cell then text will obviously show.
Change your CF formulas to
=AND(H1=TRUE,SUM(B3:D3)>20) format green
Copy this formula two more times for the other colours, amending the SUM part as necessary.
3. Change the cell formula to IF(H1=FALSE,SUM(B3:D3),"")
Copy the formula to the other cells.
So CF is no longer dependent on the value in the cell, it relies on the SUM() directly and the formula in the cell is dependent on the value in H1 as to whether text shows or not.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
You could also change the CF font color to match the CF fill color.
This will leave the numbers in the cells but you won't be able to see them.
Hi, thanks for your help
I have tired to follow your guidance but it doesn't seem to have worked for me. Cheeky I know but would you be able to edit the sheet I attached so I can see how it works?
Is not cheeky, it's only a tiny amount of data.
Does this work how you want?
I've left your original CF in.
That is exactly how I wanted it to be thanks. I can see where I was going wrong now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks