How to apply conditional formatting [Solved]

smith145 6 Posts Wednesday February 7, 2018Registration date February 8, 2018 Last seen - Feb 8, 2018 at 12:18 PM - Latest reply: smith145 6 Posts Wednesday February 7, 2018Registration date February 8, 2018 Last seen
- Feb 8, 2018 at 01:38 PM
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?

See more 

Your reply

4 replies

Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - Feb 8, 2018 at 01:28 PM
+1
Helpful
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
Was this answer helpful?  
smith145 6 Posts Wednesday February 7, 2018Registration date February 8, 2018 Last seen - Feb 8, 2018 at 01:38 PM
Solved!
Thanks for the help
Respond to Mazzaropi
Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - Feb 8, 2018 at 12:37 PM
0
Helpful
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 6 Posts Wednesday February 7, 2018Registration date February 8, 2018 Last seen - Feb 8, 2018 at 12:42 PM
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
Respond to Mazzaropi