Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Conditional Formatting (Highlighting) [Closed]

Report
Posts
6
Registration date
Wednesday February 7, 2018
Status
Member
Last seen
February 8, 2018
 -
 Blocked Profile -
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

1 reply

Answer 1 / 1

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
Posts
6
Registration date
Wednesday February 7, 2018
Status
Member
Last seen
February 8, 2018
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
Posts
6
Registration date
Wednesday February 7, 2018
Status
Member
Last seen
February 8, 2018
How do I apply the conditional formatting
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!