LinkBack URL
About LinkBacks
Hi all,
I want a formula to highlight every 2nd or 3rd row with Conditional Formatting.
Regards,
Vikas
Hi all,
I want a formula to highlight every 2nd or 3rd row with Conditional Formatting.
Regards,
Vikas
select the data which you want to highlight with conditional format and use the following formula in conditional format
=mod(row(),2)=0
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hi Vikas,
To highlight 2nd row useFormula:
Please Login or Register to view this content.
To highlight 3rd row useFormula:Please Login or Register to view this content.
Regards,
AM
Formula:Please Login or Register to view this content.
How can you use Conditional Formating.
--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks Siva & ashishmehra
Your formulas are working perfectly.
@Fotis: Thanks for your effort unfortunately the formula does deliver result. Please check.
Regards,
Kisan Vikas
Hey Vikas - Mark this thread as SOLVED if your query has been resolved so other user may not come here anymore..
Cheers!!!
Anil Dhawan
Thanks,
Anil Dhawan
Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.
Don't stop when you are tired. STOP when you are done!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks