Conditional Format Part of a Cell

[jeran042]

So here is what I would like to do. I have a cell that is a concatenation to 2 cells. Some text followed by a hyphen and the current date. I want to conditional format the date to be white font (to appear invisible) if there is no dollar amount entered in an adjacent cell.
I know the length of the part I want to format will always be 11 characters from the right.

I have been testing such a formula in the conditional formatting section, but as of yet I have had no luck,

 

[oldbrewer]

in my opinion a better approach would be to run a macro that finds instances of no dollar amount and then changes the date to white font

 

[Eric W]

You can't Conditional Format part of a cell.

Your options would seem to be:

1) Run a macro like oldbrewer suggests
2) Split the cell into 2 columns and CF the second column
3) Use a formula in the cell like:
=F1 & IF(G1="","",TODAY())

It would depend on your sheet references of course, but the gist is that the date is only concatenated to the cell if G1 (the amount) exists, otherwise it's not.

Hope this helps.