Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Conditional Formatting and the code is a puzzle to me, although I understand
its like maths with brackets etc. What I'm after is the explanation of the code below. =AND(G3<,DATE(YEAR(G3)+1,MONTH(G3),DAY(G3)) <=TODAY()) For instance =AND < "" +1 (G3 and which right Parenthesis would this apply to? ()) Where do these apply? <=TODAY I'm guessing that this implies the information to the left of this is less than todays date? Unfortunately, I find it difficult to follow written information, but once explained and especially shown, I can remember and understand what was stated. Thanks in anticipation |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formulas an easy explanation | New Users to Excel | |||
Easy Peasy | Excel Discussion (Misc queries) | |||
A better explanation of help required | Excel Discussion (Misc queries) | |||
Easy entries short procedure required | Excel Worksheet Functions | |||
new user with easy question? not easy for me | New Users to Excel |