Hi All:
I'm in desperate need of help with conditional formatting in a spreadsheet containing projected and actual dates for various medical procedures.
For example:
A B C
1 Patient Procedure X Projected Date Procedure X Actual Date
2 Patient A 01/04/2015 01/04/2015
3 Patient B 01/12/2015
4 Patient C 01/15/2015
5 Patient D 01/15/2015 01/15/2015
6 Patient E
7 Patient F 01/23/2015 01/25/2015
8 Patient G 01/23/2015
9 Patient H 01/26/2015 02/05/2015
10 Patient I 01/29/2015
11 Patient J 01/31/2015
I need the projected dates in column B to turn RED/BOLDED/ITALICIZED whenever the projected date has passed ($B<TODAY ???) AND there is no actual date listed in column C (IFBLANK($C) ???).
Could someone please tell me what formula would work to orchestrate such and to which cells the formula needs to be applied? I'm a "formula novice", so I may need it spelled out for me.
Many thanks, in advance, for your help with this. Ted.
Bookmarks