Opacity of a cell fill
There needs to be an option to control the opacity of a cell fill.
The only option now is to go to cell options > Strokes & Fill and change the tint, but the effect is not the same as opacity (that will apply only the fill and not the text in the cell).
I found a way to do this. You need to access the effects tab which allows you to change the opacity of each element individually.
From this website (the 'level' part of this is what you're looking for):
"Using the Effects Panel
For this technique, you will need to harness the Effects panel. To access the panel, choose "Window" > "Effects" from the main menu. Here, you can adjust a wide range of transparency effects, including:
Blending Mode: Adjusts how an object's colors blend with other objects.
Opacity: Changes the object, stroke, fill, or text transparency.
Level: Opacity settings for the Object, Stroke, Fill, or Text.
Isolate Blending: Applies blending to an object group.
Knockout Group: “Knocks out” or “blocks out” underlying objects, based on the opacity and blending settings.
Clear All: Clears any effects placed on an object, and reverts the blend mode to Normal.
FX: Shows a list of all transparency effects. "
really need to add this capability.
Kevin Chiang commented
Dear lord Adobe, please. I'm designing an agenda and I want to shoot myself.
Please add this feature. Greatly appreciated.
It would be very useful. Please Adobe, add this feature.
Holy moly! Can't believe changing the opacity of a cell fill is not possible! If there is a way and I am missing something please let me know.
It's silly not to be able to adjust the opacity or the blending of cells... You have to do really stupid arrangements to achieve row / column transparencies putting frames below - not professional at all.
If I had a nickel for every time someone asked me how to change the opacity of a cell fill...
I agree I million percent!