Previous Topic Next Topic

Conditional Formatting (Highlighting)

Closed
smith145 Posts 6 Registration date Wednesday February 7, 2018 Status Member Last seen February 8, 2018 - Feb 7, 2018 at 02:19 PM
 Blocked Profile - Feb 7, 2018 at 04:34 PM
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

1 response

Answer 1 / 1
Blocked Profile
Feb 7, 2018 at 03:34 PM
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!
smith145 Posts 6 Registration date Wednesday February 7, 2018 Status Member Last seen February 8, 2018
Feb 7, 2018 at 03:50 PM
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
smith145 Posts 6 Registration date Wednesday February 7, 2018 Status Member Last seen February 8, 2018
Feb 7, 2018 at 03:51 PM
How do I apply the conditional formatting

Similar discussions

Macro to delete rows if cell contains string
jonny578 -
vcoolio -

1 response
Conditional formatting with multiple rules and blank text cells
PaiviM -
PaiviM -

6 responses
Macro to Create New Workbook and Copy Data at Each Change of X
greatdanejes -
vcoolio -

1 response
How to copy a data from one sheet to another, when specific criteria is met
TomasSurvilas -
TrowaD -

13 responses
VBA to find specific text and cut and past into new worksheet.
DonalK -
TrowaD -

3 responses
Formula to subtract one cell value from another.
autigers71 -
vcoolio -

1 response