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 9309 Posts Monday June 3, 2013Registration dateModeratorStatus May 16, 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 

Your reply

4 replies

ac3mark 9309 Posts Monday June 3, 2013Registration dateModeratorStatus May 16, 2018 Last seen - Feb 7, 2018 at 03:34 PM
0
Helpful
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
Respond to ac3mark