User Tools

Site Tools


conditional

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

conditional [2017/09/28 16:37] (current)
zeppo created
Line 1: Line 1:
 +====== Conditional Formatting and Conditional Formulas ======
  
 +Highlight Rows then
 +
 +Format
 +
 +Conditional Formating
 +
 +Use Formula **Formula is** then **=$D2=1** or whatever the value and the cell is
 +
 +then choose Format color.
 +
 +I think the $ anchors it so it will always refer to that column but change according to the row.
 +
 +I now think you have the use =$d$1 to make it an "​Absoloute Reference"​
 +
 +To copy to other rows use the paint brush called Format Painter next to th Copy and Paste icons
 +
 +
 +For alternating colors on a line
 +  * Use conditional formating with
 +  * =MOD(ROW(),​2)
 +
 +**Conditional Formulas**
 +
 +   ​=IF((DATEDIF(E2,​ $K$2, "​d"​) > $L$5),​((C2*$F$52)+(D2*$F$53)),​0)
 +
 +or
 +
 +Display a message if a condition is true
 +
 +You can display a message based on a value or the results of a calculation. For example, you may want to display "​Overdue"​ for unpaid invoice items more than 30 days old.
 +
 +  - In cell D7, type **=IF((TODAY()-B8)>​30,​ "​Overdue",​ "​Current"​)**,​ and then press ENTER.
 +  - Select cell D7, and then drag the fill handle over the range of cells that you want to display the message.
 +
 +If today'​s date is more than 30 days after the invoice date, the value of the cell is "​Overdue."​ Otherwise, the value is "​Current."​
 +
 +From http://​office.microsoft.com/​en-us/​excel/​HA010918321033.aspx
conditional.txt ยท Last modified: 2017/09/28 16:37 by zeppo