Conditional Formatting: any way to make a thicker border?

  • Thread starter Thread starter Keith R
  • Start date Start date
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
 
I think you're stuck with what's shown if you want to continue to use
conditional formatting.
 
Back
Top