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 formula =B1<(A1+43)
Red formula =B1>(A1+42)
This works in row 1, but I can't seem to apply the same formula to all rows?
Many thanks in advance for your help.
- 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
Thank you SergeiBaklan this has resolved my problem, pesky $ 😀
J_Wil_93 , you are welcome
