You can use Conditional Formatting to do this.

Select your entire range of data, with active cell in top-left corner
From the Format Menu, choose "Conditional Formatting"
Change "Cell Value Is" to "Formula Is"
Enter the formula: =COUNTIF($A1:$Z1,"")0
Click the FORMAT button and select your format (bold, red)
Click OK

I assumed your data was in columns A through Z for this example. Adjust the
above formula to match your actual range.

HTH,
Elkar

"Kesbutler" wrote:

can anyone tell me if I can color the font of certain cells based on a blank
cell. I want the font for a row to be red if one cell in the row is blank.