Hi.
I have created a list through the data validation way. I have then linked it to a graph.
Is it possible to format the background of the list to the same as my sheet background?
If so, how do i do it?
Thanks.
Hi.
I have created a list through the data validation way. I have then linked it to a graph.
Is it possible to format the background of the list to the same as my sheet background?
If so, how do i do it?
Thanks.
Have you tried selecting the list cells and picked the 'No Fill' from the Font area of the Ribbon
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Hi.
Unfortunately, i cant select any of this ribbon. It doesnt allow me to. Im not sure if its possible?
Ah, sorry, I see you're still on Excel 2007 before the Ribbon was introduced.
Nevertheless for 'Ribbon' read Menu. Excel 2007 will have somewhere in its menu tabs, probably a View Tab, a cell formatting option that allows you to pick 'no fill' - or whatever 2007 refers to it as.
I don't believe you can change the white background of the data validation dropdown list.
With VBA and activex combo box, which you can change background colour of, you might be able to fashion something.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks