Conditional Formatting
Closed
Liquibox
Posts
2
Registration date
Thursday January 9, 2014
Status
Member
Last seen
January 9, 2014
-
Jan 9, 2014 at 05:20 PM
Blocked Profile - Jan 10, 2014 at 11:06 AM
Blocked Profile - Jan 10, 2014 at 11:06 AM
Related:
- Conditional 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
- Excel conditional formatting based on date - Guide
3 responses
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
Posts
2
Registration date
Thursday January 9, 2014
Status
Member
Last seen
January 9, 2014
Jan 9, 2014 at 07:04 PM
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