Conditional formatting applied to a different cell
ddahl...@officeformac.com
The entries on the sheet are first sorted by date received and then by RMA number (columns D and A respectively in my spreadsheet).
I want to apply conditional formatting such that if the RMA is at least 60 days old, I want the RMA number is highlighted in blue, and if over 100 days old, then the RMA number needs to be highlighted in red.
What is the proper structure for the conditional formatting formula? I know the TODAY() function will also need to be included...
John McGhie
=(TODAY()-A1) > 100
=(TODAY()-A1) > 60
The longest date must be first, because the first conditional format to come
true is the only one that will fire.
Get the first cell right and copy it, then select all the others and
Edit>Paste Special>Formats to copy the formulas to all the other cells.
Cheers
On 12/12/09 11:54 PM, in article 59bae...@webcrossing.JaKIaxP2ac0,
"ddahl...@officeformac.com" <ddahl...@officeformac.com> wrote:
--
The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:jo...@mcghie.name
ddahl...@officeformac.com
CyberTaz
literally :-) As I understand it your DATES are in column D, not column A,
so if, for example, they begin in D10 your Conditional Formatting formulas
for that cell should read as:
1st Condition - Formula Is: =(Today()-D10)>=100
2nd Condition - Formula Is: =(Today()-D10)>=60
Note that I also changed the comparison operator to >= because you wrote "at
least" 100 or 60 days in your previous message.
HTH |:>)
Bob Jones
[MVP] Office:Mac
On 12/13/09 8:48 AM, in article 59bae...@webcrossing.JaKIaxP2ac0,
"ddahl...@officeformac.com" <ddahl...@officeformac.com> wrote:
> It didn't work. :-/