Conditional Formatting (Highlighting)

smith145 6 Posts Wednesday February 7, 2018Registration date February 8, 2018 Last seen - Feb 7, 2018 at 02:19 PM - Latest reply: ac3mark 8804 Posts Monday June 3, 2013Registration dateModeratorStatus February 19, 2018 Last seen
- Feb 7, 2018 at 04:34 PM
Hi,

I would like to apply conditional formatting so that Cell A4 is highlighted (filled) if Cell B4 has Text (date in the format 22-DEC-17) and unhighlight Cell A4 if Cell J4 has text (date in the format 22-JAN-18)

Thanks,

Ryan
See more 

4 replies

Reply to this topic
ac3mark 8804 Posts Monday June 3, 2013Registration dateModeratorStatus February 19, 2018 Last seen - Feb 7, 2018 at 03:34 PM
0
Helpful
3
OK, so where are you stuck?

In the event that you want different values for different colors, always use least significant to most. The last true wins!
smith145 6 Posts Wednesday February 7, 2018Registration date February 8, 2018 Last seen - Feb 7, 2018 at 03:50 PM
If Cell B5 has text, then highlight A5, once text is entered in J5 unhighlight A5
If Cell B6 has text, then highlight A6, once text is entered in J6 unhighlight A6
If Cell B7 has text, then highlight A7, once text is entered in J7 unhighlight A7
If Cell B8 has text, then highlight A8, once text is entered in J8 unhighlight A8
And So on
smith145 6 Posts Wednesday February 7, 2018Registration date February 8, 2018 Last seen - Feb 7, 2018 at 03:51 PM
How do I apply the conditional formatting
ac3mark 8804 Posts Monday June 3, 2013Registration dateModeratorStatus February 19, 2018 Last seen - Feb 7, 2018 at 04:34 PM
Respond to ac3mark