Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to color ONLY the Dimension headers

Hi, I need to color the bg ONLY of the dimension headers...how can I do it???

15 Replies
its_anandrjs

Use Custome Cell Formats for this check the settings

Go to User Preferences >> Design >> Check the Always Show Design Menu Items

and then right click on the chart header to change the background color.

Not applicable
Author

nope guys, I have already done that and it colors ALL the headers! I want to color only the two headers you can see in the picture...

sujeetsingh
Master III
Master III

Use custom format cell option .

To set this option in your doc

Go to>>Setting>>User Preferences>>Design Tab>>Always Show Design Menu

sujeetsingh
Master III
Master III

Use trick Take a Text Box with same text and Size and just place it with layout as top and not moveable.

Not applicable
Author

sujeetsingh is there another way to color specif headers? I cannot add other elements on the sheet...

Not applicable
Author

Hi

Use Grid (Ctrl+G) to enable it. Then right click on the table header and select Use Custom Format Cell.

In that you can change the background colour. Hope this helps

Not applicable
Author

hi irene

you want color only for the dim or for the values also

Not applicable
Author

just the bg of the dimensions, as in the picture I posted. I don't need to color any specific value of those dimensions...

rsdhavle
Creator II
Creator II

Click  CTRL + G it will activate grid on the application. Right click on dimension header for which you want to change a color. Click on custom format cell. Then in background color change the color you want