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?

Apply conditional formatting to the selected cells so cells with a value greater than 10
Apply the moderate effect smartart style - Guide
Clear only the formatting from the selected cell - Guide
How to delete cells in word - Guide
The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
How to apply at the rate in laptop - Guide

2 responses

Answer 1 / 2

Mazzaropi Posts 1983 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

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

Answer 2 / 2

Mazzaropi Posts 1983 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?

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

Similar discussions

Clear cell contents based on value of another cell range using VBA

help me to add particular cells

Highlight cell if another cell contains specific text

How to use conditional format based on text?

Return Seq Values Until Blank value then return different set of seq values

Similar discussions

Subscribe To Our Newsletter!