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
- Excel conditional formatting if another cell contains specific text - Excel Forum
- How to clear formatting in excel - Guide
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- Phone formatting software for pc - Download - File management
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
