Forum Discussion
Conditional Formatting multi rule help!
For the green rule, you want the Patient Name cell (column D) to turn green if:
There is a date in the injection column (F), and
There is a value in the prescription received column (O).
Formula for Green:
=AND($F13<>"",$O13<>"")
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
You want conditional formatting on the Patient Name column (D) based on the Injection Date (F) and Prescription Received (O).
Highlight all the cells under D (Patient Name) where you want the formatting applied.
Go to:
Home → Conditional Formatting → New Rule → Use a formula to determine which cells to format
Then enter the following formulas one by one (adjust row numbers if your data starts somewhere else):
Red (Injection within 4 days, no prescription)
Formula:
=AND($F13<>"",$O13="", $F13-TODAY()<=4)
Yellow (Injection within 6 days, no prescription)
Formula:
=AND($F13<>"",$O13="", $F13-TODAY()<=6, $F13-TODAY()>4)
White (Injection more than 8 days away, no prescription)
Formula:
=AND($F13<>"",$O13="", $F13-TODAY()>8)
Make sure the rules are listed in this order (Red first, then Yellow, then White).
Tick “Stop if true” for each so Excel doesn’t apply multiple colors at once.
*Inserted file with various conditional formatting examples.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
Thank you NikolinoDE that worked! yay!
One more piece of help if you wouldn't mind? Could you also tell me a formula for if the patient is booked in for their injection and the prescription has been received into the clinic so that the name turns green? Thank you so much
For the green rule, you want the Patient Name cell (column D) to turn green if:
There is a date in the injection column (F), and
There is a value in the prescription received column (O).
Formula for Green:
=AND($F13<>"",$O13<>"")
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
Thank you so much!