Haddii aad rabto in aad ku codsato midabka safafka kale iyo tiirarka xaashida xaashida ee Excel , waa kuwan waxa aad u baahan tahay inaad samayso. Waxaa suurtogal ah in lagu muujiyo midabka la rabo saf kasta ama tiir ka duwan oo leh Qaabka Shuruuda^{(Conditional Formatting)} ah . Shaqadani waxay ku jirtaa Microsoft Excel , waxaadna ka faa'iidaysan kartaa iyadoo la kaashanayo casharradan.

Aynu ka soo qaadno inaad u samaynayso xaashida xaashida mashruucaaga dugsiga ama xafiiska, oo waa inaad midabaynaysaa saf kasta ama tiir kasta oo kale. Waxaa jira laba siyaabood oo taas lagu sameeyo  Microsoft Excel . Marka hore^(First) , waxaad dooran kartaa saf ama tiirar gaar ah oo aad gacanta ku beddeli kartaa midabka asalka. Midda labaad^(Second) , waxaad isticmaali kartaa  qaabaynta Shuruudaha^{(Conditional Formatting)}  ah ee shaqaynta si aad isku mid ugu codsato otomaatiga. Si kastaba ha noqotee, natiijadu waxay noqon doontaa isku mid, laakiin habka labaad ayaa aad waxtar u leh oo waqti u badbaadiya isticmaale kasta.

Sida loo beddelo midabada safafka ee Excel

Si aad u codsato midabka safafka kale ee Excel , raac tillaabooyinkan-

1. Ku fur xaashida xaashida Excel.
2. Dooro safafka iyo tiirarka aad rabto inaad midabayso.
3. Guji Qaabaynta Shardiga^{(Conditional Formatting)} ah ee tabka Guriga .^(Home)
4. Ka dooro Xeer Cusub^{(New Rule)} liiska.
5. Dooro Isticmaal qaacido si aad u go'aamiso unugyada la habaynayo^{(Use a formula to determine which cells to format)} .
6. Geli =MOD(ROW(),2)=0 or =MOD(COLUMN(),2)=0sanduuqa qiyamka qaabka
7. Guji badhanka Qaabka^(Format)
8. U beddel tabka Buuxi^(Fill)
9. Dooro midab aad rabto inaad isticmaasho.
10. Guji badhanka OK laba jeer.^(OK)

Aynu si faahfaahsan u eegno tillaabooyinkan.

Marka hore, ku fur xaashida xaashida ee Excel . Haddii ay dhacdo, aadan haysan xaashida, samee marka hore si aad u fahmi karto inaad rabto inaad midabayso safafka ama tiirarka. Marka la sameeyo, isticmaal jiirkaaga si aad u doorato dhammaan unugyada (safka iyo tiirarka). Haddii aad rabto inaad nidaamka midabka ku dabaqdo xaashida xaashida oo dhan, dhagsii calaamadda fallaadha taasoo kuu ogolaanaysa inaad ka doorato xaashida xaashida kor ilaa hoos.

Hadda iska hubi inaad ku jirto   tabka Guriga . ^(Home)Hadday sidaas tahay, dhagsii  Qaabaynta Shuruudaha ^{(Conditional Formatting )} ee  qaybta Hababka ^(Styles ) , oo liiska ka dooro  Xeerka Cusub ee ^{(New Rule )} doorashada.

Taas ka dib, dooro  Isticmaal qaacido si aad u go'aamiso unugyada qaabaynta^{(Use a formula to determine which cells to format)}  doorashada, oo ku qor mid ka mid ah kuwan  sanduuqa qiyamka- ^{(Format values )}

• = MOD( ROW(),2)=0
• = MOD (COLUMN(),2)=0

Midka kowaad wuxuu midabayn doonaa midabka la rabo ee safafka kale kan labaadna waa tiirarka. Taas ka dib, dhagsii  badhanka Format  .

Hadda, u beddel  tabka Buuxi ^(Fill ) , dooro midab aad rabto inaad isticmaasho, oo guji  badhanka OK  .

Kadib, waa inaad mar labaad riixdaa  badhanka OK  si aad u codsato isbeddelka.

Waa intaas! Hadda waxaad ku arki kartaa midabka la doortay saf kasta ama tiir kasta oo kale.

How to apply Color in alternate Rows or Columns in Excel

If you want to apply color in alternate rows аnd columns in an Exсеl spreadsheet, here is what you need to do. It іs possible to show the desіred color in every alternate row or column with the Conditional Formatting. This functionality is included in Microsoft Excel, and you can make use of it with the help of this tutorial.

Let’s assume that you are making a spreadsheet for your school or office project, and you have to colorize every alternate row or column. There are two ways to do that in Microsoft Excel. First, you can select particular rows or columns and change the background color manually. Second, you can use the Conditional Formatting functionality to apply the same in automation. Either way, the result will be the same, but the second method is more efficient and time saving for any user.

How to alternate row colors in Excel

To apply color in alternate rows or columns in Excel, follow these steps-

1. Open the spreadsheet with Excel.
2. Select the rows and columns that you want to colorize.
3. Click the Conditional Formatting in the Home tab.
4. Select New Rule from the list.
5. Select Use a formula to determine which cells to format.
6. Enter =MOD(ROW(),2)=0 or =MOD(COLUMN(),2)=0 in the Format values box.
7. Click the Format button.
8. Switch to the Fill tab.
9. Select a color that you want to use.
10. Click the OK button twice.

Let’s check out these steps in detail.

At first, open the spreadsheet with Excel. In case, you do not have the spreadsheet, create it first so that you can understand whether you want to colorize the rows or columns. Once done, use your mouse to select all the cells (rows and columns). If you’re going to apply the color scheme to the entire spreadsheet, click the arrow icon that allows you to select the spreadsheet from top to bottom.

Now make sure that you are in the Home tab. If so, click on the Conditional Formatting in the Styles section, and select the New Rule option from the list.

Following that, select the Use a formula to determine which cells to format option, and write down one of these in the Format values box-

• =MOD(ROW(),2)=0
• =MOD(COLUMN(),2)=0

The first one will colorize the desired color in alternate rows and the second one is for columns. After that, click the Format button.

Now, switch to the Fill tab, select a color that you want to use, and click on the OK button.

Then, you will have to click the OK button again to apply the change.

That’s all! Now you can see the selected color in every alternate row or column.

Related posts

• Sida loo beddelo tiirarka safafka gudaha Excel oo wata foomamka

• Sida loo beddelo safafka iyo tiirarka gudaha Excel

• Sida Looga Badalo Saafka ama Saafka Excel [Tallaabo Talaabo]

• Sida loo qaboojiyo safafka iyo tiirarka gudaha Excel

• Safka Kooxda iyo Tiirarka ku jira xaashida shaqada ee Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo abuuro Shaxda Radar gudaha Windows 11/10

• Sida Dhakhso Loo Geliyo Safaf Badan gudaha Excel