Formula to make cell text bold based on other cell value?

[lichldo]

I have the following formula already in a cell - =IF('Project Estimate'!A4=0, "", 'Project Estimate'!A4)

It's working great by pulling data from another sheet. Some of this data will start with " - " before the text. Is there a way to add to the above formula, that if that cell its pulling from does NOT start with " - ", then make the cell Bold text?

 

[lichldo]

So, then do you only want to highlight the cell with the dash, or the whole row?
Is there any possibility of any entry in any other column (not listed) starting with " - "?

I want to bold the cells that do NOT have the " - "

 

[Joe4]

I want to bold the cells that do NOT have the " - "

I understand that, but can you PLEASE answer the two questions I asked?

So, for the first one, let'say that cell A3 does NOT start with " - ".
Then do you just want A3 bolded, or the whole entire row 3?
If the whole entire row, what if A3 does NOT start with " - ", but D3 does?
Then who wins that conflict?

For my second question, you said you want to look at columns A, D, G, J, M, P, S, V and Y.
Is there any possibility that the other columns not included in that list (i.e. columns B, C, E, F, ...) start with " - "?
It would make it MUCH easier if they do not. Then we do not need to worry about checking each column separately, which could make for a very long messy formula.

 

[lichldo]

I have the following formula already in a cell - =IF('Project Estimate'!A4=0, "", 'Project Estimate'!A4)

It's working great by pulling data from another sheet. Some of this data will start with " - " before the text. Is there a way to add to the above formula, that if that cell its pulling from does NOT start with " - ", then make the cell Bold text?

I've solved this by making a conditional formatting rule on the entire sheet by selecting the "format only cells that contain" rule and setting to "specific text not containing" "-"