| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional formating for the month
I have a column with the birthday of some clients and I want the cell format
to change to yellow when his date of birth is withing the current and the next monat. In order to do that I wrote these formula in the first and second field of the conditional formating panel=C2=MONTH(TODAY()) and =C2=MONTH(TODAY())+1 , but it doesn't work. Can't you tell me what am I doing wrong Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
| Conditional Formating & Rand() function | Excel Discussion (Misc queries) | |||
| conditional formating | Excel Discussion (Misc queries) | |||
| Conditional Formating | Excel Discussion (Misc queries) | |||
| more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
