Ask a question Report

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

Excel Ask a question Report

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

Your reply

Reply to this topic

4 replies

Report Respond to ac3mark

ac3mark 9309 Posts Monday June 3, 2013Registration dateModeratorStatus May 16, 2018 Last seen - Feb 7, 2018 at 03:34 PM

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!

Report Respond to smith145

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

Report Respond to smith145

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

Report Respond to ac3mark

ac3mark 9309 Posts Monday June 3, 2013Registration dateModeratorStatus May 16, 2018 Last seen - Feb 7, 2018 at 04:34 PM

Give this a try:
http://ccm.net/forum/affich-1013945-use-conditional-formatting-to-highlighting-cells-based-on-name

Your reply

Reply to this topic

Ask a question