Related:
- Change a cell content according with the color of another cell
- Changing a cell value based on the color of a ✓ - Forum - Office Software
- When you want to change a cell color which menu should you select ✓ - Forum - Excel
- Excel VBA – In a column, change only cells that - How-To - Excel
- How to change your cell phone number t mobile - Guide
- Change same cell in multiple sheets - Guide
1 reply
That Cell is a function, and in this case, "the value 1 if the cell is formatted in color for negative values; otherwise returns 0 (zero)."
You can write a user defined function in such a manner...
press Alt-F11, and Insert New Module
In that module define a new function such as:
Now in the cell(A1) that you want to see what the color is type in
=ColorN(B4)
And if B4 is Purple, that cell will display the index of purple .
Now Change your cell Into a "-" based on a value in A1.
I hope this helps!
Have FUN!
It's kind of fun to do the impossible! -Walter Elias Disney
You can write a user defined function in such a manner...
press Alt-F11, and Insert New Module
In that module define a new function such as:
Function ColorN(Cell_Color As Range) ColorN = Cell_Color.Interior.ColorIndex End Function
Now in the cell(A1) that you want to see what the color is type in
=ColorN(B4)
And if B4 is Purple, that cell will display the index of purple .
Now Change your cell Into a "-" based on a value in A1.
I hope this helps!
Have FUN!
It's kind of fun to do the impossible! -Walter Elias Disney