Conditional Formatting: any way to make a thicker border?

K

Keith R

I am trying to automate a process (which produces a report) that someone
is currently doing manually;

Cells are colored and given borders conditional on the cell value:

If cell value is <70, it is red fill with white bold text
If cell value is >= 70 and <90 it is green fill with black text
If cell value is >=90 it is green fill, black text, but with a very thick
blue border added (so it is easily visible, otherwise it is hard to detect
against the green fill).

I can get all three conditions, but the border options for the third
condition in conditional formatting only give me half as many options as
when I format the cell by hand. Is there any way to get a thicker border,
or am I stuck with the thin borders in the dialog box?

Many thanks,
Keith R
 
D

Dave Peterson

I think you're stuck with what's shown if you want to continue to use
conditional formatting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top