# spreadsheet-editor-conditional-formatting

> Spreadsheet loads a workbook containing conditional-formatting rules to demonstrate formatted data presentation in a workbook.

**Framework:** blazor  **Component:** Spreadsheet  **Variant:** conditional-formatting

## Get this item

**If you are an agent, fetch the JSON.** Source is inlined, so one request is enough and no tooling is required:

```
GET https://ai.syncfusion.com/r/blazor/spreadsheet-editor-conditional-formatting.json
```

**Install Package(s)**

```bash
dotnet add package Syncfusion.Blazor.Spreadsheet
```

**Notes**

- Syncfusion release: 2026 Volume 2 (v34.1.29)
- The Syncfusion package is licensed. The composition in this file is source you own and edit. See https://ai.syncfusion.com/licensing.md

## Source files

### src/components/spreadsheet-editor-conditional-formatting/SpreadSheetEditor.razor

```razor
@page "/spreadsheet/conditional-formatting"
@using Syncfusion.Blazor.Spreadsheet
@using System.IO;
<div class="col-lg-12 control-section">
    <div class="content-wrapper">
        <div class="row">
            <div>
                <SfSpreadsheet DataSource="DataSourceBytes" @ref=_spreadsheetInstance>
                    <SpreadsheetRibbon></SpreadsheetRibbon>
                </SfSpreadsheet>
            </div>
        </div>
    </div>
</div>
@code {
    public byte[] DataSourceBytes { get; set; }
    public SfSpreadsheet _spreadsheetInstance { get; set; }
    protected override void OnInitialized()
    {
        //Sets the excel file path for initial loading.
        string filePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "src", "blazor", "spreadsheet-editor", "conditional-formatting", "conditionalformatting.xlsx");
        DataSourceBytes = File.ReadAllBytes(filePath);
    }
}
```

### src/components/spreadsheet-editor-conditional-formatting/conditionalformatting.xlsx

```xlsx
PK    �T�\��Nx�  �     xl/sharedStrings.xmllT]��0�+V�Kb�CM� p�J�8>��o�Y��?R{���W�'�d��h<;;v��W��}P�2�)2�V����A������y��Xk��+�Zd]�1��y5چAv&j��y�g4:�A{5��
�Oyh<�!���\E/7�l6�5����^В�7V�@������|���U���`�K�n�`�zy��l�LTk�Z��cr��Q%���m�b������n�;Fk��Ɩ�����<F�R�%uT�U�e��\*��(�t�<�o{>�{��ױf���O�H��'�U�xDd�� ф�����FV�ib�Ѧ,ů�8�����M]F˲ɪg`�%�_HL
�JQ$N54�6��ηR�u�O�6y4-���S����l���W�$����O��N��=��$t����d� �ְJ#<X�x�E�t����kC�h�/���UgP�eܮx/��C}����v�a�h�  �� PK    �T�\�Nk?�	  +%     xl/worksheets/sheet1.xml�Zێ�8���EQ77dږ����γZ��Bt�J�n���E��DRr���`�a_���X<U,�Ɏ�Օ�J��l�-�+Y�)�S�\�腝�Y=˛S^�ݢ��G?%�[�}�)e֭����ۢgƮ�u_<�:�W�6��:�]��~�v�u{>�M�⥦[���;Z�l�����HZ�aof�.����3[m-M��kG�w����f�Y�y���bfh��:ﾼ\����9+�ʪd_�{����]<u�[�\�+��]*i�=>͖��%1_��Z'�i��:zޢG�p�����o���b��#=�=�*�F�kI߶�� U�b��gZт��adA��������EJ����B�DV^��N��O>q�֣OI<}��x�|��gm}���m�^(�N���T���m�>�Y�U��E[Yu	���:�	��{�"��0$	}$M�&���Pu����7!�+?tv��I�&5���I=��O��
{N�9�L�����F8i�U䅁���"�M�����&�q�Os�'q׾YL͛~��C�,�0�<�>F%q� �,�E=J��ĉׯI�.��n�Xˑ�l$��f#�l��l䨎���m\��,e]��0�E��<6��K���~.At�t.������Kds�@��0�u��\"%4��"YD�i3*�,ة6`OxZ`�Xu
�l�D���X�A�C��lB�V�C
&b�$^������+	L'��OqB��[��S(�f�h���^8����8q�j
����F�e81�٩w�!>2�9Jd��Ƈ�ȇ��a���@c��/c,8�yF>�l$e6����w���H�tq�Ny�Q,R��L�b�h��
�@P�)�3RB��)��Ƅ�N�vܡD����U4F�EFB���N�d؇���&#0�����`3I&pb$���#B|`$
�$?
�h֧�u8�"����
�9��8#F��0��������M��Gd��>���G����$Z~l��(l�fQ�@��nD~̊*�3����A��	�M����N7w��~`��Q��/4J���	��k$�NG�Ҋ�W�k���|��bpy�Q��LA'Z�c�p�.��Rc`&R�a8J7�����v���S)���NG���ǘ3㚋OAmʘhe�Ƀ�h��
9�N�EX&G�7����G�)Q<�Ɂ�n���u���a5�c�]N���OAm$��.����v��
9��b�9b��l��QzJ�o*h��Q�V׈��(1���~��4���G�dG��3�
=�Na�˹#4z"l�t�����s�v����uk�Q<�Xx�����5q�6S�]b*�`^ɯg��^�+5~6�,}$�"S0t��3\ Hmh�au�c�&�2�X4���3$�)"w� ]b�Y4�
A���{}��r (�$;߱��ف&q���U��^�n�E_��<����~�Q�2U�	��彥7��g$�Qz�&@'��r�6�v�5�X����Fƥ�6���vt�p��+�v
e���c%��W5�u~�\�Gmzɬ2��7�̢�tg] \�N�Fj����*�Dv��5�Rc�U���=0�edM[Xp#�^ŵ\M������}i���Q�ZY\��umN%��畸�ees��oF`UI\�}��ž^�e14j��Y\'[׮l��}�dO-cm�o����"|���*O����0�M�)�	��iq]���+��a�� 6�9�,���G�a~m%/5�X��\����
�7j������eY@v�p'B3ڥ7��gILo�z��-�}�~�!��w��ػ ����=dYr�c|���/I|��CyJ~w�<yĳϾ�mG�ޜ����S�$?���x-��5�����W0��������]Q�M4��R��Q���}�?/:E����	��c�$"���4|�������| �Q)hU�܏��EV{�]��n�*���|�u#A�0��PㆯSu���ٓ�����>yEU/��(FD߶j�\�UM��W��a%��{�w��,Z�E@Q�A�@��P$�찋<QWTy�x�����K�]ʦ�*zf[�Bdu�Ŏf핏������Ǣg��hAֹm��e������ۿ��9m�^^���ܼX���v�aY���	�ơ�N�W�Eu^�h����#��9��~�;s��'�C���uq�(�E�\ĆW�z�n��(No���1�W�.���L���p��˰�,)�E�3�;xzV�3K�I|���<��E��{5�7��Bg8S��XN2�����)ɑ��9WRn��F��%*��x���-z�9(9���Sۉ���K��J
홃��#m.�����;<�;Z@W�EE�0zc�j�%���]��y��k��j�F�Ed��]���o�Ԅ)���9+�y~ �Z�Kc
q��I�����*��T�)��T�<��ο]���W��]���C��������T;�����   �� PK    �T�\X��t�       xl/styles.xml�Xmo�6�+3��jJN�D����f @Q�(���(�(_4�
�����,Y��tm�x���&O���wO�j��'JS)��(dIE���T/n ��3)H�D�Wi�͖�kB�p&�-/�6��EHk±�Ɇ�g�T=��F��m󢐼���Q�E� XB��ۻZH�sF�	�p;�ns ��BI-+3+$G��hA�n����qf%G(B��GL<��DS�X�|ō�l�I`ؓ�rW&0\^A�O�ɒ$��Zi^��.~��fA Jc��K�J�A�5�4�_�=f	C����xB��u�b��&�?�[yg!�>ɭ�{�^��wǒ���4�(c}p�mP�Ҹ��%V�1Э��6$�B
bߪ3ɤT�dC��Di������1�JQU+�狧���4Υ*���lʓҘ���S(Z����ƝJ#�]��R`f�h��-t���H}�zs�[�j/]����̵K�X�����
��pӰ�kFk�����ƝzؿkyN��UɁj�{ؽWҐ¸�|�'g���<tr=y�Cg�\�=��g�=����[��1�����ˡIx�ו�o�S�\Y�]��̖�)�7N�l��;?	�D�b�-,?��NW�4n�N0Y|�G7un�4F�m�o�?Vz�}��6����b���ٿn�®�yhg����Z*�E
c��C�؈��>���S-��'XuԆ|xt��f<�vt�p/ٿ�ǏIu����~6��{3�XG�ٙ��!�2C����#���C��`����G9����k9�Zz�e7M���JQl{�����TuL#m7#����e��W�x�X���;qO��j�Rm޺T�$k�pS�N��'����i~/C��4.7��}	�~�F9��G���Pu��U��ݓly���_�Q<�6Aݗ-�i�T�� ��hH9P\8p�3;ʂ`��0ޮ�ep���;'���x�k�NccQUw�}�uU{ r�  �� PK    �T�\8��M  @     xl/workbook.xmll�Ak�0����}q�l+I
c;��tg�VS�
��f�~$M��$��>=*W�5�>hrdI
�$�ݾ�>6w������'сָ���1vK΃lъ�P�n��!oE	�=���_H�]�y�ܣQ���̴![�𬖞51�dg�G�B���y��<˸�ͨ�?��B��L��Fܝ�`��ޅ�
̈_���*�f脿��{mFu���5��g��Y�V��9I`
ћ�m�^�V��S��c�;��p���H�?�)�P�Sen2�vGt��{�!���� �ZU��*���˾Fn<kzc6���(L���a��/�P  �� PK    �T�\����   7     xl/_rels/workbook.xml.rels��Aj�0E�"f_�N��%�n�ms!�eI#4�־}��ԁP��r����v?�>�q�b`�zPX�X����ϠXl�6QA2�w�7LV"�be5�T��$R_�f7a��Q�2�4R�V��t��d�M�?�f�5S��v���R�?l����9c���ډ'Du�-��D�����s�o�l�iò$�_�����ǻ�O���KXk�㋍�z��  �� PK    �T�\�̷�   �      docProps/app.xmlL�Ak1F�J��M� "�,B{�IO�k��j �	�Q�/*m�~����0����8�z�Y� #�	O��ȴ�h�p�z}փw�F�$`5����H���%pGp.y�V�pG�dh�R�O��(fe���,�#���'���j�)I���PR��'��ޙ��A_�~��쇵O�ws�?��  �� PK    �T�\;b	m*  6     docProps/core.xml���j�0�_ň^m�m�6�v)=�Ph��7!m�I���/��Iin�j���V�^��7����I�I�+�9����#IB�F�����4�pLX�o�:�QaHzݚ����1F�(ug�f��[�hb�y�S���7�rEj/o�RL�B�A-`�uYW�c 9�|}yG�<Uf�%p�F��F"d֡�u��^���ŉ� +�1r�#��*R��4�Lx����sdw خ�*z%UR�E'e�Ŧ���Qn�vϤ)�X�p���]�\3x��~���m�ګ$�ME�ܺ�  �� PK    �T�\OX6&�   �      docProps/custom.xml��A
�0 �����T"�i/>��x�$ِݖ��"����㞢ڰr�l�ܴ�0;�B���O7P,6O6RF2�C��T�J@V{���M,"�Ӛ݂�rC󞢧��pCu��}px'�&̢/m{���Ư�Q��������ҩ�z���  �� PK    �T�\�W�Q  �     [Content_Types].xml���N�0�_��5�8 ��� \a�@H�6ZG�;��G�B��1�S����d��/���a��\�DѠu��D�uy/
b���; �Z.�w	�胏T��9=(E���Ib��_c�IbnT�f�P��ٝ2"�<d���	j�y.�{�������܀��N�;��aT�:Y���D�6�#��[Mf�c:�.��񺅜��b�3�� �P�W�;$�5O������YRʠ-� �܇�E�:�}��bsu����D>1o>7������{Gj\�W6.8O�X4댉�N��0<�Ldv0=�?p�.�f���c�z��s���Of�  �� PK    �T�\����   �     _rels/.rels���N�0�W�|_��Z��������&q����=�P���������X������`۴ 0�.�
F�6� 
�h���
�X�x�?���(��KE��cQpaNRs��KC	c��4��r/�6��Q���N�0�'� �����pM7u�3�Hfyf��&@�u�T/�(/DCS�!�1���`e��&eJ��a�Y2O�R�:�E��z�ﻗY[�Zʸ�H,�n׋�����S�C���2��k�  �� PK-     �T�\X��t�                   xl/styles.xmlPK-     �T�\��Nx�  �                   xl/sharedStrings.xmlPK-     �T�\�Nk?�	  +%                 xl/worksheets/sheet1.xmlPK-     �T�\8��M  @                 xl/workbook.xmlPK-     �T�\����   7               �  xl/_rels/workbook.xml.relsPK-     �T�\�̷�   �                �  docProps/app.xmlPK-     �T�\;b	m*  6               �  docProps/core.xmlPK-     �T�\OX6&�   �                �  docProps/custom.xmlPK-     �T�\�W�Q  �               �  [Content_Types].xmlPK-     �T�\����   �               (  _rels/.relsPK    
 
 �  N    
```
