keyongtech


  keyongtech > excel.* > excel.misc > 11/2004

 #1  
11-19-04, 02:43 PM
newby blues
Can the cell color change with the input of color coded text (ie: R - Red =
fail, P - green = pass etc.)
 #2  
11-19-04, 02:49 PM
Frank Kabel
Hi
have a look at 'Format - Conditional Format'

"newby blues" wrote:
Similar Threads
How to change color in cell when there is input

Example Col A is fill Green, cell format is general - Color disappear when text is enter Col B is fill Blue, cell format is currency - Color disappear when number is enter

How do I change cell color in excel based on text input?

I want the cell format (meaning color of the cell) to change based upon the text entered. I have used up the conditioal formatting. It only allows three formats, and i...

Color-coded cell references

I've lost the color highlights that show which cells my total refenences when I double click on the total, anyone know how to get them back?

Change color of cell after user has input a number

I have a spreadsheet that populates a number of cells. The user has the option to change the cell values. Now, ifthe user changes a value, I want the value to be of a...

Color Coded cell references.

Is ther alimit to the number of arguments in afromuls for the color coding of cell listed tin the formuls to revert to black?


All times are GMT. The time now is 04:40 PM. | Privacy Policy