Excel Tips: Highlight alternate rows with Conditional formatting

preview_player
Показать описание
Hello Friends,

In this video you will learn how to Highlight alternate rows with Conditional formatting. It will increase readability of your data

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Facebook:

Telegram:
Рекомендации по теме
Комментарии
Автор

The formula, for anyone else who is struggling to see it, is.. =isodd(row()) .. had to go to another video to figure it out but still appreciated the info!

michellemendez
Автор

after searching for 1, 5 app. why the formula =mod(row.. etc doesn't work, I found you and your formula works!!!! thanks a lot. :D

noaj
Автор

Thanks! Needed this today. =ISODD(row()) / be used in CF formula,

jamesperry
Автор

AWESOME PK..always come up with innovative ideas!!

varungupta
Автор

Hi, can you please help me to understand a string with combination of if, Isnumder, search

RitikaSharma-dgzc
Автор

What is the formule if I want to highlight alternate rows with conditional formatting while using a filter ?

PhenomenonChu
Автор

Hello PK: I wanted to know how if can apply the same formula for entire sheet. like when am entering any date in column and when i hit enter to move to next row the colour of next row automatically changes to different colour.

kanhaiyalalsahani
Автор

I already seen this trick in Mr Sujeet Video.

paravej
Автор

Indian man strikes again on explaining specific stuff lmao

buddhaswag
Автор

Formula you type is not visible..pls write it here

rinkusvlogsandlifestyle