Conditional formatting: If the # in a cell is < than 2 and the month has passed (the column header for that cell is January and now it is February) I would like that cell with the # in it to turn red and blink if possible.
Conditional formatting: If the # in a cell is < than 2 and the month has passed (the column header for that cell is January and now it is February) I would like that cell with the # in it to turn red and blink if possible.
Last edited by kener41; 01-26-2005 at 09:30 AM.
As long as the column heading is entered as a date (formatted as to only show the month - format code of MMMM), the the following conditional format can be used as follows:-
Assume the month is in cell A1 and the number is in A3
=IF(AND(A3<2,MONTH(TODAY())<>MONTH(A1)),TRUE,FALSE)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks