- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Conditional Formatting question
Posted on 11/7/14 at 8:02 am
Posted on 11/7/14 at 8:02 am
Hey guys,
I have a spreadsheet here at work that helps me manage the jobs within my group. I want to set up a conditional format that reads if the actual date of a job is completed before or after the committed date. I've looked through the dates section of formulas that are already there, and it has nothing. Is this formula possible?
I have a spreadsheet here at work that helps me manage the jobs within my group. I want to set up a conditional format that reads if the actual date of a job is completed before or after the committed date. I've looked through the dates section of formulas that are already there, and it has nothing. Is this formula possible?
3
Posted on 11/7/14 at 8:10 am to finchmeister08
I just selected "Conditional Formatting", then "Highlight Cell Rules...Greater Than" and selected a date field. Entering a date beyond the target turned the cell the selected color. On or before left the cell the default color.
Posted on 11/7/14 at 10:44 am to finchmeister08
Yes. I assume completed date and committed date are in separate columns, with each row having a separate date.
Select the cells you want to apply the formatting, Under conditional formatting, formulas, for example put "=B3>F3" (not including quotes). This assumes B column is completed date, and F column is committed date and Row 3 is first data row. If you select the entire column, the 3 becomes 1.
Select the cells you want to apply the formatting, Under conditional formatting, formulas, for example put "=B3>F3" (not including quotes). This assumes B column is completed date, and F column is committed date and Row 3 is first data row. If you select the entire column, the 3 becomes 1.
This post was edited on 11/7/14 at 10:45 am
Posted on 11/7/14 at 5:38 pm to finchmeister08
thanks guys. worked like a charm.
Page 1 of 1
Back to top
Follow TigerDroppings for LSU Football News