Conditional formatting for specific field

Hello,

Can someone help with the following please?:

In the sheet "Final" of attached there's a field called "Make appointment Before".
When the value in this column is below 0 I would like it to change to bold and red.
I have tried using conditional formatting but this doesn't work if the field's location is changed.

Note: To change location, select "Show Fields" then "Refresh"

Thanks in advance

Hello there,

Try adding the below code after the End with in the Sub Refresh() and before the End Sub

Please Login or Register  to view this content.

So that it look like below:

Please Login or Register  to view this content.

Let me know if this works!

Thanks!

Hi rvasquez,

Thanks for your response I tried this but it ony works if the "Make appointment before" field is in column E.
If I select "Show Fields" then change the column location to say "F" and hit "Refresh", the format remains in Column E.
Is there anyway to update it when the column location changes?

Thanks in advance!

Hello,

Attached is the latest workbook using rvasquez code.
If you hit the refresh button now, "Make Appointment Before" has no formatting.
Is there anyway to update it when the column location changes?

Thanks in advance!

Bump........

Hi,

I'm not sure what you mean but ive uploaded the file again

Thanks.

Bump........

Hello,

Can someone help with this please?

Thanks in advance

Bump no response