Re: Conditional Formatting

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Hi peter,

Example: in the cell A7 select conditional formatting > formula is
"=D7<>0" (dont include the " marks)
then select format > font style >bold
Repeat for other cells or copy as required
this will change the font to bold

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30736
View this thread: http://www.excelforum.com/showthread.php?threadid=531801

.

Relevant Pages

  • Re: How to count number of Cell have Strike Through Effect & Bold as font style.
    ... Maybe the bold or strikethrough is created by Conditional Formatting? ... Value in Cell C1:20 ... Now my question was how to count no of cells with Bolds.& Red Strike ...
    (microsoft.public.excel.misc)
  • Re: Banding with Conditional Formatting with Multiple Conditions
    ... of BOLD or BOLD ITALICIZED. ... cell BOLD or BOLD ITALICIZED, the cell is shaded and the contents of the cell ... as well as other conditional formatting that I already have set up. ... the shading of odd numbered rows, but after having set up conditional ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Trouble w/ conditional formatting and dates
    ... In cell E2 enter the following formula and copy it down as necessary: ... Select the range with these formulas and click the Bold button, ... before the expiration date or on the expiration date then say "Call Client". ... I'm having trouble with a formula in conditional formatting. ...
    (microsoft.public.excel.misc)
  • Banding with Conditional Formatting with Multiple Conditions
    ... I can set up banding using Conditional Formatting fust fine. ... For example, when cell F69 is greater than cell D72, I need it to ... but not BOLD and ITALICIZED. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Multiple conditional formats
    ... To highlight the cell, use the PATTERNS tab. ... When I go to conditional formatting, I can only change the font style. ...
    (microsoft.public.excel.misc)