Cell formatting if cells are italicized

[darxide23]

I've asked this question in the Formulas subforum but was informed that this can't be done except with VBA so I'm asking here. Reference to other post: http://www.excelforum.com/excel-form...talicized.html

I'm trying to figure out how to use conditional formatting if a set of cells is italicized.

See the attached sample. Attachment 358930

I want to fill the values in columns E through Z with 20% red only if that rows value in column A is italicized and I want no fill if the value is not italicized. For example, if A2 is italicized then I want E2 through Z2 filled with 20% red.

I haven't found anything via Google on how to do this so I'm asking here.

Thank you.

I know this is a simple VBA but my Excel programming-fu isn't very strong, yet. I know I'd be using If Cell.Font.Italic = True but I have tried to hack at it and get it to work but can't quite get it.