champracer29
New Member
- Joined
- Oct 5, 2007
- Messages
- 12
Morning,
I managed to get entire row with conditional formatting depending on one cell (which is based on categories for each different colors).
Now I am wondering if Excel could turn off the entire row of conditional formatting if insert a date in different cell on same row?
Example:
Column: A - Case number, B - Name, C - Issue, D - Category, E - Date
Row: list of tickets
If there category is picked as 'Bug' then it turn in red entire row. But if the date is inserted, then the entire row should be no color, (no fill).
Is that possible? - Thanks those who can answer this.
I managed to get entire row with conditional formatting depending on one cell (which is based on categories for each different colors).
Now I am wondering if Excel could turn off the entire row of conditional formatting if insert a date in different cell on same row?
Example:
Column: A - Case number, B - Name, C - Issue, D - Category, E - Date
Row: list of tickets
If there category is picked as 'Bug' then it turn in red entire row. But if the date is inserted, then the entire row should be no color, (no fill).
Is that possible? - Thanks those who can answer this.