Skip to main content
Apr 4, 2022 10:06 AM UTC
Solved

WriteableTextColor

Hi All,
 
Does anyone know of a formatting string that will allow us to edit the textcolor of writeable cells in a cube view? I could split out the columns so that we have locked and writeable cells seperately and then we edit the textcolor of all the rows, but what I am looking for is almost a "WriteableBackGroundColor = White", but for TextColor.
 
I tried using "WriteableTextColor" (a string I tried to derive), but it unfortunately doesn't do anything
Veteran
Apr 4, 2022 10:58 AM UTC

Try exploring conditional formatting.

If cell is readonly Then

 color1

else

color2

End If

I do not see readonly property in conditional formatting options though. See if you can use any other property there.

BhartiParyani_0-1649069761968.png

 

4 replies

Veteran
Apr 4, 2022 10:24 AM UTC

Try using just TextColor.

Apr 4, 2022 10:36 AM UTC

Hi Bharti,

Thanks for this. However I am trying to have separate textcolors. One for cells where a user is not able to input data, and the other for cells where they can (Writeable cells).

Any ideas?

Veteran
Apr 4, 2022 10:58 AM UTC

Try exploring conditional formatting.

If cell is readonly Then

 color1

else

color2

End If

I do not see readonly property in conditional formatting options though. See if you can use any other property there.

BhartiParyani_0-1649069761968.png

 

Apr 4, 2022 11:32 AM UTC

Thanks Bharti, we came right using this idea.