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 to change color in cell when there is input
 

Select col A (A1 active)
Click Format Conditional Formatting
Formula is: =ISTEXT(A1)
Click Format Patterns tab select "No color"
OK out

Select col B (B1 active)
Click Format Conditional Formatting
Formula is: =ISNUMBER(B1)
Click Format Patterns tab select "No color"
OK out

Test it out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"TSK" wrote:
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 to change color in cell when there is input
 

Thank You

what if the cell contain alphanumeric? What should type in the formula?
Please what

"Max" wrote:

Select col A (A1 active)
Click Format Conditional Formatting
Formula is: =ISTEXT(A1)
Click Format Patterns tab select "No color"
OK out

Select col B (B1 active)
Click Format Conditional Formatting
Formula is: =ISNUMBER(B1)
Click Format Patterns tab select "No color"
OK out

Test it out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"TSK" wrote:
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 to change color in cell when there is input
 

Sorry I had figure it out with alphanumeric.

Thank You Thank You

"TSK" wrote:

Thank You

what if the cell contain alphanumeric? What should type in the formula?
Please what

"Max" wrote:

Select col A (A1 active)
Click Format Conditional Formatting
Formula is: =ISTEXT(A1)
Click Format Patterns tab select "No color"
OK out

Select col B (B1 active)
Click Format Conditional Formatting
Formula is: =ISNUMBER(B1)
Click Format Patterns tab select "No color"
OK out

Test it out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"TSK" wrote:
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 to change color in cell when there is input
 

Can someone base on Max advise tell how can it work with date input cos I
tried inserting the following command but it dun work. Thank You

Formula Is == ISDATE(A4)

"TSK" wrote:

Sorry I had figure it out with alphanumeric.

Thank You Thank You

"TSK" wrote:

Thank You

what if the cell contain alphanumeric? What should type in the formula?
Please what

"Max" wrote:

Select col A (A1 active)
Click Format Conditional Formatting
Formula is: =ISTEXT(A1)
Click Format Patterns tab select "No color"
OK out

Select col B (B1 active)
Click Format Conditional Formatting
Formula is: =ISNUMBER(B1)
Click Format Patterns tab select "No color"
OK out

Test it out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"TSK" wrote:
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 to change color in cell when there is input
 

See reply to your other post - have patience !!

Pete


On May 7, 8:36*am, TSK wrote:
Can someone base on Max advise tell how can it work with date input cos I
tried inserting the following command but it dun work. Thank You

Formula Is == ISDATE(A4)

How to change color in cell when there is input
 

Formula Is == ISDATE(A4)

As responsed in your new post ..
Think you could try this
Formula is: =LEFT(CELL("format",A1))="D"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---