Miguelluis
New Member
- Joined
- Jan 29, 2013
- Messages
- 45
Hi
I'm stuck with this one, the below is an example of what I'm trying to achieve. I need to highlight the rows depending on the values on D and F. I've done =NOT(ISBLANK($P1)) in conditional formatting to highlight the rows when a date is entered in column D but I can't figure out how to override this if 'Yes' is entered into F. In short I want to shade grey if there's a date in D but shade yellow if yes is populated in F. If no is entered in F it stays grey.
<tbody>
</tbody>
Thanks
Miguel
I'm stuck with this one, the below is an example of what I'm trying to achieve. I need to highlight the rows depending on the values on D and F. I've done =NOT(ISBLANK($P1)) in conditional formatting to highlight the rows when a date is entered in column D but I can't figure out how to override this if 'Yes' is entered into F. In short I want to shade grey if there's a date in D but shade yellow if yes is populated in F. If no is entered in F it stays grey.
A | B | C | D | F |
Test | Test | Test | 12/09/14 | Yes |
Test | Test | Test | 01/09/14 | No |
Test | Test | Test | 05/08/14 | Yes |
<tbody>
</tbody>
Thanks
Miguel