View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Cheryl Cheryl is offline
external usenet poster
 
Posts: 144
Default Bold Row if Col E is bold

I did not use conditional formatting. I am opening a file from another
format (which cannot be electronically edited) which has this cell as bold in
certain situations. I am opening in excel and saving in excel format so my
team members have an electronic copy to modify/update. I would like to have
a routine that says
Look at current sheet
if Col e bold = true
then Col A:D, F:L bold = true
Can someone help me to do this?

"Don Guillett" wrote:

Assuming you used conditional formatting for cell E, can''t you just use the
same conditional formatting for A:L?

--
Don Guillett
SalesAid Software

"Cheryl" wrote in message
...
I would like to bold the whole row (A:D, F:L)if the text in col E is bold.
Can someone help me with this?