Comparing each days sales
Closed
Jai
-
3 Mar 2011 à 08:05
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 4 Mar 2011 à 09:00
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 4 Mar 2011 à 09:00
Related:
- Comparing each days sales
- Skype last seen days ago - Guide
- Excel add days to date - Guide
- How many days does it take facebook to review your account - Guide
- You have 179 days left to request a review - Facebook Forum
- Android sales force application - Download - Business management
2 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
3 Mar 2011 à 10:27
3 Mar 2011 à 10:27
Hi Jai,
Use conditional format: top menu > format> conditional format.
On the window that appears, select "Formula is" in the first dropdown list.
Enter the following formula:
Now drag the cell down and choose "Format only" from the small square that appears to apply the conditional format to the rest of the column.
Best regards,
Trowa
Use conditional format: top menu > format> conditional format.
On the window that appears, select "Formula is" in the first dropdown list.
Enter the following formula:
=AND(A1>=0%,A1<=100%)Choose your color and add another condition with formula:
=AND(A1>100%,A1<=120%), choose your color and for your final condition use this formula:
=A1>120%, choose your color and hit OK.
Now drag the cell down and choose "Format only" from the small square that appears to apply the conditional format to the rest of the column.
Best regards,
Trowa
***rich***
Posts
1
Registration date
Wednesday 2 March 2011
Status
Member
Last seen
3 March 2011
3 Mar 2011 à 11:23
3 Mar 2011 à 11:23
you don't mention what version of office you have. here is a good link for 2007:
http://office.microsoft.com/...
http://office.microsoft.com/...
3 Mar 2011 à 11:24
3 Mar 2011 à 11:27
4 Mar 2011 à 09:00
You can post (a sample of) your file using a site like www.speedyshare.com.
Also explain what isn't working for you.
Best regards,
Trowa