Conditional Formatting

I have 2 cells:

A1 (yes or no value)
B1 (numeric value)

I want to apply conditional formatting to cell B1 that says if A1="yes" then
contents of B1 are bold.

How can I do this?
.

Relevant Pages

  • Row number changes in conditional format formula during VB executi
    ... I have a spreadsheet with some cells that have conditional formatting. ... the print preview icon also runs the Workbook_BeforePrint event. ... conditional formatting formula always reference the row of the cell where the ...
    (microsoft.public.excel.programming)
  • Re: Conditional Computing
    ... and given how important conditional formatting ... exposed in the object model. ... It would be nice if cells had a ... Private Sub Worksheet_Calculate ...
    (microsoft.public.excel.programming)
  • RE: Ignoring highlighted cells
    ... If the cells were formatted due to applying Conditional Formatting, ... >> (show in bold) eg. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How can I display a warning if calculations indicate original data
    ... above it, it will return a value of 1, but any duplicates above it will cause ... use Conditional Formatting with the condition being Formula Is ... spreadsheet program will be used by unskilled people. ... conflicting cells if the user entered the data into the cell. ...
    (microsoft.public.excel.programming)
  • Re: Counting the number of rows based on the color
    ... Dim intCount As Integer, FC As FormatCondition, blnMatch As Boolean ... Using Conditional Formatting, I color the cells in a column based on its ... Red and Yellow cells. ...
    (microsoft.public.excel.misc)