04-04-2022 06:06 AM - last edited on 05-24-2023 12:29 PM by JackLacava
Solved! Go to Solution.
04-04-2022 06:58 AM
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.
04-04-2022 06:24 AM
Try using just TextColor.
04-04-2022 06:36 AM
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?
04-04-2022 06:58 AM
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.
04-04-2022 07:32 AM
Thanks Bharti, we came right using this idea.