Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Conditional Formatting
Ive searched this question and could not find the answer. How do I set conditional formatting to bold A1 if A2 is empty? Thanks |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do I set conditional formatting to bold A1 if A2 is empty?
Select A1, then apply this as the CF's Formula Is: =ISBLANK(A2) Format to taste, ok out -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
To conditionally format your cell(s): In 2003: 1. Select the cells you want to format (A1) 2. Choose Format, Conditional Formatting 3. Choose Formula is from the first drop down 4. In the second box enter the formula: =A2="" 5. Click the Format button 6. On the Font tab pick Bold style 7. Click OK twice. In 2007: 1. Highlight all the cells on the rows you want formatted 2. Choose Home, Conditional Formatting, New Rule 3. Choose Use a formula to determine which cell to format 4. In the Format values where this formula is true enter the following formula: =A2="" 5. Click the Format button and choose the Font tab, then Bold. 6. Click OK twice If this helps, please click the Yes button. Cheers, Shane Devenshire -- If this helps, please click the Yes button Cheers, Shane Devenshire "Jim" wrote: Conditional Formatting Ive searched this question and could not find the answer. How do I set conditional formatting to bold A1 if A2 is empty? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |