Conditional formatting Pt. 1: Highlighting numeric and text values

preview_player
Показать описание
Analyze and find values in spreadsheets quicker with conditional formatting🔍

0:07 Highlight top values
0:38 Highlight bottom values
0:51 Find values above the average
1:09 Search for values above the specified number
1:23 Reveal values between the lower and higher limits
1:37 Find words in cells

In ONLYOFFICE Docs you can apply pre-configured or custom rules to highlight any content, including:

✅ Exact matches
✅ Largest/Lowest values
✅ Values above or under the average
✅ Text inputs
✅ Data
✅ Duplicates
✅ Blank cells

📢Subscribe and tap the bell to stay informed about ONLYOFFICE news🔔
Рекомендации по теме
Комментарии
Автор

Well yeah but when i sort the pivot table for top 10 it also selects my total which i dont want is there a way to make it so it marks only the values in the pivot table that arent the grand total

petarivanov
Автор

Farei um vídeo em português e divulgarei no meu canal também.

fabiobasso
join shbcf.ru