Formatting - conditional and otherwise

MMGroup

Board Regular
Joined
Jul 10, 2002
Messages
50
I want to have a cell's format reflect:
a) the range of the number in the cell (e.g., 95% = green) and
b) a significance factor which cannot be stated in a conditional formatting rule (i.e., it must be set manually).

There are several ways which work manually (colored text, colored background; colored text, colored borders, etc) two show two factors, but conditional formatting seems to take over the format for the field. That is, even if the only thing changed in the conditional format is the background color, font color can then not be changed manually. Excel 2000. Any ideas how to do the formatting any way other than 100% manually?
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

MMGroup

Board Regular
Joined
Jul 10, 2002
Messages
50
Well, I answered my own question. If the format IS specified in the conditional formatting, then it will ignore manual attempts to change it. If it is not specified in the conditional formatting, it can be manually changed.

To fix my current problem, I set the font to a color in the conditional format and set the background to CLEAR (vice no color)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,669
Messages
5,838,686
Members
430,563
Latest member
Raeyven

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top