Coniditional formatting
Closed
Tony
-
Aug 17, 2012 at 03:23 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 11, 2012 at 10:34 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 11, 2012 at 10:34 AM
Hello,
I am trying to write a code that will scan input dates and compare them with dates in the cell
next to them. If the dates input are farther than a week out i want to color the cell green; if the cell is greater than the one next to it, but less than a week greater, then i want to color the cell yellow; if the cell input is less than the cell next to it then i want the cell to turn red. Would anybody be able to help me with this problem?
Thanks
I am trying to write a code that will scan input dates and compare them with dates in the cell
next to them. If the dates input are farther than a week out i want to color the cell green; if the cell is greater than the one next to it, but less than a week greater, then i want to color the cell yellow; if the cell input is less than the cell next to it then i want the cell to turn red. Would anybody be able to help me with this problem?
Thanks
Related:
- Coniditional formatting
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
- Formatting windows 7 - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Sep 11, 2012 at 10:34 AM
Sep 11, 2012 at 10:34 AM
Use conditional format for that