Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
How to add background for few selec
Name: Praveen Kulkarni Date: August 15, 2008 at 03:08:05 Pacific OS: Windows XP CPU/Ram: Intel-2GB Product: HP
Comment:
Hi all, Can anybody help me how to add back ground for only few selected cells in a excel sheets..?hope you got the point..however we can add background for entire sheet,but i want only for particular cells..?
Name: timexed Date: August 15, 2008 at 06:18:55 Pacific
Reply:
If your referring to colored background or shading cells then do the following:
Highlight or select the cells in question, goto Format>Conditional Formatting>Formula Is
add the following in the box: =MOD(ROW(),2)=1
and then choose the type of format you desire. Hope this helps.
one time, some time, all the time...All about the past moment
0
Response Number 2
Name: DerbyDad03 Date: August 15, 2008 at 10:13:28 Pacific
Reply:
Please define what you mean by "background".
It is as simple as cell shading or the more complex Format...Sheet...Background?
0
Response Number 3
Name: timexed Date: August 15, 2008 at 14:55:40 Pacific
Reply:
I was wondering if you were just trying to alternate shading on select cells. The commands I listed will provide the alternate shading on cells. Are you referring to an image background such as a watermark?
one time, some time, all the time...All about the past moment
Summary: There is a thread in this forum describing how to add 30 days to a month in Excel. It is pretty easy. (If the date is in A1, then "=A1+30" is 30 days later.) What if, instead of adding 30 days, I...
Summary: I am trying to setup a machine that exports a PowerPoint slideshow to a set of TVs setup in the atrium of our college. So far I have a basic PowerPoint show working, but I would like to add a bit m...
Summary: Hi Bryan, Well the ignorance is on my part totally. Did I fail to mention novice? :-) I do know how to download music and save it to my play list and burn my music to a CD using Windows Media Player 9...
0 
Excel formula date
