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.

ExcelKita Logo ExcelKita Logo
Sign InSign Up

ExcelKita

ExcelKita Navigation

  • Home
  • Blog
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog

Conditional Formating

Share
  • Facebook
0 Followers
3 Answers
3 Questions
Home/Conditional Formating

ExcelKita Latest Questions

Asked: August 11, 2022In: Conditional Formating

Memberi warna pada cell yang berisi sama

Anonymous
Anonymous
Memberi warna pada cell yang berisi sama

Adakah cara utk memberi warna, jika time tsb sama ,berada didalam satu kolom terima kasih

leftright
  • 0
  • 1 Answer
  • 19 Views
Asked: July 26, 2022In: Conditional Formating

Mewarnai Nilai yang sama

Anonymous
Anonymous
Mewarnai Nilai yang sama

Bagaimana Cara mewarnai Nilai yang ada di Table 2 berdasarkan Table 1 yang nilainya sama  

  • 0
  • 1 Answer
  • 14 Views
Asked: June 21, 2022In: Conditional Formating

Bagaimana memberi warna pada bilangan bulat saja

Anonymous
Anonymous

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
  • 0
  • 1 Answer
  • 38 Views

Sidebar

Ask A Question

Stats

  • Questions 30
  • Answers 21
  • Best Answers 21
  • Users 36
  • 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 dengan menggunakan IF dan YEAR untuk mengecek tahu lahir… December 6, 2022 at 8:32 am
  • Andi Setiadi
    Andi Setiadi added an answer Misalkan tanggal 27 Oktober 2022 ada di kolom A1 Cara… October 21, 2022 at 11:21 am
  • Andi Setiadi
    Andi Setiadi added an answer Bisa gunakan REGEXEXTRACT =REGEXEXTRACT(A2,"= Rp.(\S+)") October 21, 2022 at 11:11 am

Trending Tags

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

Explore

  • Home
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Tags
  • Badges
  • Users
  • Help
  • Our Blog
    • Excelnoob.com
    • ArrayFormula.com
  • YouTube

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