• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 436
  • Last Modified:

Gradient fill

I'm trying to remove what appears to be a gradient fill in a row of cells.

I've tried everything I can think of but it will not clear and become solid or no color.
  • 4
1 Solution
Harry LeeCommented:

Have you tried Clear Formats? If not try it. It should remove all formatting.

You could have conditional formation setup for the range. Check if there is.

If those did not help, upload the file and I'll look at it.
You can just cancel the window you have there and just click a single colour in the palette or 'no colour'.

This should be all it requires.
two of the same colour won't work :(
mikecox_Author Commented:
Barman: I tried to no color option

No color option
Can't figure why there is no "one color" option in the "fill effects" option

Will check Harry's suggestion now
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

mikecox_Author Commented:
Harry, I couldn't figure out how to clear formatting; and I didn't want to clear data. I was also unsure how to check for conditional formatting.

So what I did, to resolve the problem, was click the "format painter", select the format that was working and "paint" it into the cells in question.  That cleared the current format and I was able to reformat the cells without the "fill effects".
mikecox_Author Commented:
I answered my own question
mikecox_Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now