| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| color/shade cell upon input | Excel Discussion (Misc queries) | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| Change color of cell after user has input a number | Excel Discussion (Misc queries) | |||
|
How do you change font color based on the value input? 1 = |
Excel Discussion (Misc queries) | |||
Hybrid Mode
