Forum Discussion
Conditional Formatting - Dates
Column A = date of referral, Column B = date patient is seen I would like the cell in column B to turn green if the patient is seen within or at 6 weeks (42 days), and red if exceeded. Green fo...
presumably you are using the custom formula option in conditional formatting and those formulas are correct. The Applied To range should be B1:B100 or something like that and it should work. Please explain what is not working or provide a sample sheet or link to the sheet (not private information please)
Thank you for your help, I'm led to believe excel adds two $ automatically when clicking a cell (?making it absolute), by removing the second $ the formula worked
