Sign Up

Mendaftar untuk memulai bertanya, menjawab pertanyaan dan terhubung dengan angota Excelkita

Have an account? Sign In

Have an account? Sign In Now

Sign In

Masuk untuk memulai bertanya, menjawab pertanyaan dan terhubung dengan angota Excelkita

Sign Up Here

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lupa password? silahkan masukan email address. link reset password akan dikirimkan melalui email.

Have an account? Sign In Now

You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Sign InSign Up

ExcelKita

ExcelKita Logo ExcelKita Logo

ExcelKita Navigation

  • Home
  • Blog
  • Download File
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • Download File
Home/ Questions/Q 201
Next
Answered
Anonymous
  • 0
Anonymous
Asked: June 21, 20222022-06-21T06:03:01+00:00 2022-06-21T06:03:01+00:00In: Conditional Formating

Bagaimana memberi warna pada bilangan bulat saja

  • 0

Bagaimana memberikan warna secara otomatis pada Nilai yang bulat saja, misalnya didalam Sheet ada nilai

62166.91 42159.26 49957.46
38711.03 57455 45561.07
17118.86 23096.39 73358.54
77505.24 23603.55 14890.35
606950 74058 53549.79
13367.94 14692.87 32677.76
50192.32 56708.42 94.16
58333.67 64883.97 71312.69
29025 17656.17 38971
47654.93 36528.74 55279.45
conditional formatingmod
  • 1 1 Answer
  • 25 Views
  • 0 Followers
  • 0
Share
  • Facebook
  • Report
Leave an answer

Leave an answer
Cancel reply

Browse

1 Answer

  • Voted
  • Oldest
  • Recent
  • Random
  1. Best Answer
    Andi Setiadi Enlightened
    2022-06-21T06:05:00+00:00Added an answer on June 21, 2022 at 6:05 am

    Untuk mengecek bilangan bulat atau bukan, bisa gunakan fungsi MOD dengan Divisor 1, bilangan bulat akan menghasilakan 0.

    Maka pada Conditional Formating rumusnya menjadi
    =MOD(Cellnya,1)=0

    • 1
    • Reply
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
      • Report

Sidebar

Ask A Question

Stats

  • Questions 24
  • Answers 25
  • Best Answers 16
  • Users 21
  • Popular
  • Answers
  • Anonymous

    Rumus Urut Dengan Spin Button

    • 3 Answers
  • Anonymous

    Bagaimana Menjumlahkan Data Sesuai Kode Text

    • 2 Answers
  • Anonymous

    Bagaimana memberi warna pada bilangan bulat saja

    • 1 Answer
  • Andi Setiadi
    Andi Setiadi added an answer Bisa gunakan Networkdays.INTL =NETWORKDAYS.INTL(TglAwal,TglAkhir,"1111101",RangeLiburNas) 1111101, adalah hari dari senin sampai… August 13, 2022 at 1:43 am
  • Andi Setiadi
    Andi Setiadi added an answer Karena jumlah Text yang akan di cek sama, bisa gunakan… August 11, 2022 at 8:03 am
  • Andi Setiadi
    Andi Setiadi added an answer Untuk menjumlahkan dengan kriteria bisa gunakan SUMIF dengan Kriteria "<0" July 26, 2022 at 11:18 am

Related Questions

  • Anonymous

    Memberi warna pada cell yang berisi sama

    • 1 Answer
  • Anonymous

    Mewarnai Nilai yang sama

    • 1 Answer

Trending Tags

and concatenate conditional formating countif day eomonth find formula frequency if index left len lookup macro max mid min mod networkday.intl offset question quotient randbetween right rumus setting sumif sumproduct text trend upper vba vlookup wildcard

Download File

  • Excel Addin
  • Excel Ebook
  • Excel File
  • Excel Macro

Explore

  • Home
  • Download File
    • Excel Addin
    • Excel Ebook
    • Excel File
    • Excel Macro
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Tags
  • Badges
  • Users
  • Help
  • Our Blog
    • Excelnoob.com
    • ArrayFormula.com

Footer

ExcelKita

Excelkita adalah tempat diskusi, bertanya, tanya jawab seputar Microsoft Excel dan Spreadsheets.

About Us

  • Meet The Team
  • Blog
  • About Us
  • Contact Us

Legal Stuff

  • Terms of Use
  • Privacy Policy
  • Cookie Policy

Help

  • Knowledge Base
  • Support

Follow

© 2022 ExcelKita. All Rights Reserved
With Love by Andi Setiadi

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.