The Animal
Active Member
- Joined
- May 26, 2011
- Messages
- 449
Hi
I would like a conditional format formula that red fills cell M6 if EITHER cell I6 OR J6 is blank and only if H6 has a value in the cell. If cell H6 does not have a value conditional format is just ignored.
So the object is that there should always be a value in both I6 and J6 if there is a value in H6, if either I6 or J6 has a value missing M6 will fill color red.
Thanks for any help
Stephen
I would like a conditional format formula that red fills cell M6 if EITHER cell I6 OR J6 is blank and only if H6 has a value in the cell. If cell H6 does not have a value conditional format is just ignored.
So the object is that there should always be a value in both I6 and J6 if there is a value in H6, if either I6 or J6 has a value missing M6 will fill color red.
Thanks for any help
Stephen