How to apply conditional formatting [Solved/Closed]

Report
Posts
6
Registration date
Wednesday February 7, 2018
Status
Member
Last seen
February 8, 2018
-
smith145
Posts
6
Registration date
Wednesday February 7, 2018
Status
Member
Last seen
February 8, 2018
-
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)
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.
What would be the code used to apply this?

2 replies

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
smith145, Good afternoon.

Select A5:A1000 (as your necessity)

Conditional Format Menu --> Using Formula -->

=AND($B5<>"", $J5="")

Format Fill Color as desired --OK

Is that what you want?

I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3902 users have said thank you to us this month

smith145
Posts
6
Registration date
Wednesday February 7, 2018
Status
Member
Last seen
February 8, 2018

Solved!
Thanks for the help
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
smith145, Good afternoon.

I'm confused by your explanation.

Your request has nothing to do with the image you have set as an example.
They are two different things.

Please, would you mind repeating exactly what you need?
smith145
Posts
6
Registration date
Wednesday February 7, 2018
Status
Member
Last seen
February 8, 2018

When a date is entered in Cell B5 I want Cell A5 to be "filled" and when Cell J5 has a date entered, I want Cell A5 to revert back to "no fill". This will be applied to all rows within the table