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.
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!