How to change color in cell when there is input

[TSK]

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

 

[Max]

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

 

[TSK]

Thank You

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

 

[TSK]

Sorry I had figure it out with alphanumeric.

Thank You Thank You

 

[TSK]

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)

 

[Pete_UK]

See reply to your other post - have patience !!

Pete

 

[Max]

Formula Is ==> ISDATE(A4)

As responsed in your new post ..
Think you could try this
Formula is: =LEFT(CELL("format",A1))="D"

---