LinkBack URL
About LinkBacks
Everything works wonderfully. One last question and this should be perfect.
1. If either B3 or C3 "the dates" has a blank cell it causes A3 "the names" to go white instead of being either red or green.
Everything works wonderfully. One last question and this should be perfect.
1. If either B3 or C3 "the dates" has a blank cell it causes A3 "the names" to go white instead of being either red or green.
Hi,
I arranged it so that if A is blank then neither B nor C are coloured.
If A has a value then the colour stays white until there is stuff in B:E to evaluate.
If as you say B for example has a date and nothing else in C:E what colour should A be? i,e, what is the specific rule?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks