Conditional Formatting
Closed
Liquibox
Blocked Profile - Jan 10, 2014 at 11:06 AM
- Posts
- 2
- Registration date
- Thursday January 9, 2014
- Status
- Member
- Last seen
- January 9, 2014
Blocked Profile - Jan 10, 2014 at 11:06 AM
Related:
- Conditional Formatting
- Conditional formatting if cell does not contain specific text ✓ - Forum - Excel
- Conditional formatting if another cell contains any text ✓ - Forum - Excel
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
- Copy conditional formatting from one row to another ✓ - Forum - Excel
- If cell contains date then conditional format - Guide
3 replies
Liquibox,
OK, well today is (or tomorrow will BE!) your lucky day!
You have won the BEST formatted question award!
We need to know what version of Excel, if you would be so kind!
Hang tight, after we know which version, we can show you how to use the BUILT-In function of conditional formating in EXCEL! It is a tool. Are you having troubles writing the conditional formulas?
OK, well today is (or tomorrow will BE!) your lucky day!
You have won the BEST formatted question award!
We need to know what version of Excel, if you would be so kind!
Hang tight, after we know which version, we can show you how to use the BUILT-In function of conditional formating in EXCEL! It is a tool. Are you having troubles writing the conditional formulas?
Liquibox
Jan 9, 2014 at 07:04 PM
- Posts
- 2
- Registration date
- Thursday January 9, 2014
- Status
- Member
- Last seen
- January 9, 2014
Jan 9, 2014 at 07:04 PM
Microsoft Excel 2010
Ok, to build a formatting rule, select a cell like here:

Then make a selection of When to format, I have selected the First one:

Now you, write the formula, and select the Colors:

Then...you have this.....


I understand that this is very brief, and really if you look at it, it performs no real task ("oh my gosh, I waited this long for this?" Is what you are thinking!). The point of this was show how to use the conditiona formatting tool.
Just build the logic around your ship date cell!
Have fun! Post back if you still have issues!
//ark
-Moderator/Contributor

Then make a selection of When to format, I have selected the First one:

Now you, write the formula, and select the Colors:

Then...you have this.....


I understand that this is very brief, and really if you look at it, it performs no real task ("oh my gosh, I waited this long for this?" Is what you are thinking!). The point of this was show how to use the conditiona formatting tool.
Just build the logic around your ship date cell!
Have fun! Post back if you still have issues!
//ark
-Moderator/Contributor