Highlight column C (Call signs). Go to Home > Conditional Formatting > Highlight Cell Rules > Duplicate Values. Choose “Light Red Fill.” Now, if you type a call you have worked before, it will glow red.
The specific frequency or band (e.g., 20m, 40m) used for the contact. Mode: The communication method (e.g., SSB, CW, FT8, FM). ham radio log sheet excel template
| Feature | Description | |---------|-------------| | | Date (UTC), Time (UTC), Band, Mode, Call sign, RST sent/received, Name, QTH, Grid square | | Auto-calculations | UTC offset from local time, duplicate call detection | | Drop-down lists | Bands (160m–70cm), modes (SSB/CW/FT8/AM), power levels (QRP/Low/High) | | Contest-ready | Optional columns for serial numbers, CQ zone, ITU zone, exchange info | | Summary sheet | QSO count per band/mode, unique calls, points estimate | | Print-friendly | Designed to fit on A4 or Letter without cutting off columns | Highlight column C (Call signs)
Highlight column C (Call signs). Go to Home > Conditional Formatting > Highlight Cell Rules > Duplicate Values. Choose “Light Red Fill.” Now, if you type a call you have worked before, it will glow red.
The specific frequency or band (e.g., 20m, 40m) used for the contact. Mode: The communication method (e.g., SSB, CW, FT8, FM).
| Feature | Description | |---------|-------------| | | Date (UTC), Time (UTC), Band, Mode, Call sign, RST sent/received, Name, QTH, Grid square | | Auto-calculations | UTC offset from local time, duplicate call detection | | Drop-down lists | Bands (160m–70cm), modes (SSB/CW/FT8/AM), power levels (QRP/Low/High) | | Contest-ready | Optional columns for serial numbers, CQ zone, ITU zone, exchange info | | Summary sheet | QSO count per band/mode, unique calls, points estimate | | Print-friendly | Designed to fit on A4 or Letter without cutting off columns |