ponedjeljak, 19. listopada 2026.

How to Use Conditional Formatting in Excel

How to Use Conditional Formatting in Excel



  • What is Conditional Formatting?
  • How to Highlight Duplicates
  • How to add Color Scales
  • How to add Data Bars in Excel
  • Highlight Overdue Dates
  • How to add Icon Sets in Excel
  • How to View and Edit Conditional Formatting Rules
  • Rule Order Matters
  • How to create an In-Cell Progress Bar
  • How to Highlight Every Other Row
  • Conditional Formatting Based on Another Cell
  • How to create a Formula Rule
  • How to Highlight an Entire Row
  • How to Highlight Based on a Range
  • How to Highlight Values NOT in a Range
  • Create a Gantt Chart
  • Use Data Bars to Compare Two Groups
  • Control Scaling by Linking Min/Max to Cells
  • Change Number Formatting with CF Rules
  • Change Date Formats to d/m/yyyy
  • Hide Zero Values
  • Automatic Indenting
  • Display 23K, 23M, 23B Based on Value
  • Display Custom Icons
  • How to Copy Conditional Formatting
  • Conditional Formatting is Volatile

ponedjeljak, 12. listopada 2026.

Free online CAD 3D viewer and converter - by CADprops

 Free online CAD 3D viewer and converter - by CADprops


https://www.cadprops.com/

"...Open parts and assemblies quickly in your browser. View and measure without an account. Register or sign in to convert, save files and create share links. Recipients can view shared models without an account...."
"Open your 3D CAD file ... File size: up to 50 MiB per file · View without an account...
Supported formats: STEP / STP / IGES / IGS / STL / OBJ / 3MF / GLB / GLTF / ZIP / DXF / DWG / SVG / PDF / SLDPRT / SLDASM / PRT / IPT / IAM / JT / SAT / SAB / X_T / X_B / CATPART / CATPRODUCT / 3DM / PAR / PSM / ASM..."

CAD 3D model viewer
Distance - Point coordinates - Edge  - Angle - Hole / circle - Surface area - Solid volume
Measure - Section - Structure - Display - Convert

CAD 3D model converter

petak, 9. listopada 2026.

IMAGE OF MERCIFUL JESUS - SLIKA MILOSRDNOG ISUSA

 THE FIRST IMAGE OF MERCIFUL JESUS - VILNIUS (LITHUANIA)

HRV
„Želim da cijeli svijet upozna moje beskrajno milosrđe” (Dnevnik, 687).
„Po ovoj ću slici udjeljivati ​​mnoge milosti,
zato neka joj svaka duša ima pristup” (Dnevnik, 570).

ENG
"I desire that the whole world know My infinite Mercy" (Diary, 687).
"By means of this Image I shall be granting many graces,
so let every soul have access to it" (Diary, 570).


Download the Sacred Image of Merciful Jesus:



2) https://www.brothersofmercifuljesus.org/the-worship-of-divine-mercy/the-sacred-image-of-merciful-jesus/download-the-sacred-image-of-merciful-jesus/


Excel in SolidWorks (Design Table Explained)

Excel in SolidWorks (Design Table Explained)

...SolidWorks Design Table Tutorial! 🎥 In this video, I’ll show you how to automate your 3D parts using Design Tables — a powerful feature that connects Excel with SolidWorks to control dimensions, features, and configurations automatically....

utorak, 6. listopada 2026.

How to Insert the current Excel file name, path, or worksheet in a cell !?

How to Insert the current Excel file name, path, or worksheet in a cell !?

1--Puna putanja / path:
=CELL("filename", A1) 
vraća punu putanju, naziv datoteke i naziv trenutnog lista u Excelu, uz uvjet da je radna knjiga spremljena.

2--Samo naziv datoteke:
=MID(CELL("filename", A1), SEARCH("[", CELL("filename", A1)) + 1, SEARCH("]", CELL("filename", A1)) - SEARCH("[", CELL("filename", A1)) - 1)

3--Samo naziv datoteke i naziv lista:
=RIGHT(CELL("filename", A1), LEN(CELL("filename", A1)) - FIND("]", CELL("filename", A1)))


🔊 WARNING !!!   NAPOMENA !!! 🔊
WPS Office (and Excel configured with European regional settings) uses a semicolon (;) instead of a comma (,) to separate function arguments.
Ova gore NAPOMENA znači da je potrebno sve zareze (,) zamijeniti sa točka zarez (;) u slučaju kada je vaš EXCEL postavljen sa "European regional settings".  

Npr. tada formula br.2 glasi:
=MID(CELL("filename";A1);SEARCH("[";CELL("filename";A1))+1;SEARCH("]";CELL("filename";A1))-SEARCH("[";CELL("filename";A1))-1)