How to change color in cell when there is input

  • Thread starter Thread starter TSK
  • Start date Start date
T

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
 
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
 
Thank You

what if the cell contain alphanumeric? What should type in the formula?
Please what
 
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)
 
Formula Is ==> ISDATE(A4)

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

---
 
Back
Top