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?
 

Some videos you may like

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)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,328
Members
414,054
Latest member
Sameer50

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