Previous Topic Next Topic

How to apply conditional formatting

Solved/Closed
smith145 Posts 6 Registration date Wednesday February 7, 2018 Status Member Last seen February 8, 2018 - Updated on Feb 12, 2018 at 05:17 AM
smith145 Posts 6 Registration date Wednesday February 7, 2018 Status Member Last seen February 8, 2018 - 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?

2 responses

Answer 1 / 2
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 8, 2018 at 01:28 PM
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
smith145 Posts 6 Registration date Wednesday February 7, 2018 Status Member Last seen February 8, 2018
Feb 8, 2018 at 01:38 PM
Solved!
Thanks for the help
0
Answer 2 / 2
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 8, 2018 at 12:37 PM
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?
0
smith145 Posts 6 Registration date Wednesday February 7, 2018 Status Member Last seen February 8, 2018
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
0

Similar discussions

Conditional formating - apply on more cells
Biljana -
Raj -

32 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses