Comparing each days sales
Closed
Jai
-
Mar 3, 2011 at 08:05 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 4, 2011 at 09:00 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 4, 2011 at 09:00 AM
Related:
- Comparing each days sales
- Skype last seen days ago - Guide
- How to calculate 90 days from date in excel - Guide
- Move files older than x days windows - Guide
- Days calculator - Download - Calculators
- Oracle datediff in days - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Mar 3, 2011 at 10:27 AM
Mar 3, 2011 at 10:27 AM
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 March 2, 2011
Status
Member
Last seen
March 3, 2011
Mar 3, 2011 at 11:23 AM
Mar 3, 2011 at 11:23 AM
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/...
Mar 3, 2011 at 11:24 AM
Mar 3, 2011 at 11:27 AM
Mar 4, 2011 at 09:00 AM
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