I didn't understand, do you changed value display and cell/font color in cell with original value, or in another location. When in original location, then you can use conditional formatting (when in anothoer location, then really too - you have to add tha formula which reads the value from original cell.
So the basic case. Select the range with values, activate conditional formatting, and add a rule for every scenario (in my example I assume, that the values are in range A2:B10);
1st scenario (value = 0).
Create a new rule. Select "Use a formula to determine which cells to format" (this selection goes for all rules). Enter the formula
=(A2)=0)
Click <Format>, activate tab Number, select category Custom, and enter into Type field "blue". Activate tab Fill, and select blue color. Activate tab Font, and select white font color. <OK>. <OK>;
Repeat the same cycle for all 4 scenarios;
Check that Stop if True is unchecked for all rules. When checked, then uncheck;
<OK>. <OK>.
The cells are colored according your schema for all 4 shema values, and in standard colors for all other values. And those 4 numbers are displayed as color names instead of numbers.
NB! Really the values remain numbers, they only are displayed differently. So you can make any mathematical calculations with them like with other numbers.
|