conditional format

[mdarsot]

shipment#, counts#, date
1 123 mar-02
2 345
3 554
4 228 mar-03
5 343
6 334 mar-04


For better visibility i want to put a conditional format formula where it will put a underline after each date apperiang column. So it will underline at mar-02, mar-03 & mar-04.

 

[AnotherHiggins]

Select the three columns, making sure that A1 is active.

Go to Format > Conditional Formatting

Change the first box to Formula Is

In the second box, type in =not(isblank($C1))

Change the formatting to whatever you want.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

Hi,

Use Format > Conditional Formatting....

Use Formula is: =C2>0

Format the BOTTOM BORDER

assuming that you are using REAL DATES

faq68-5827

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[mdarsot]

Great thanks. two more question. is it possible to color one block of date white shade and next following a gray throughout the sheet.

#2. How can i break a subtotal line in the sheet that will total the counts column above from last date to the next date.

ie.

shipment#, counts#, date
1 123 mar-02
2 345 // white shade
3 554
sub total 1022
4 228 mar-03
5 343 // gray shade
sub total 571
6 334 mar-04
7 226 // white shade
sub total 560

 

[SkipVought]

What grouping value is your subtotal based on?

Use that value to make a known numeric value, for instance if the grouping value were in column A...
[tt]
G2: =if(A1=A2,G1,G1+1)
[/tt]
Then CF on
[tt]
=Mod(G2,2)=0
[/tt]
This value will "toggle" between 0 & 1.





Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}