Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filling conditional formatting
I want cell A1 to be the color red if B1=1 and yellow if B1=2. I have figured
out how to do this with conditional formatting, but how do i fill the conditional formatting for A2-A100 without creating a conditional format for each a cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
filling conditional formatting
2 ways ..
1. Simply use the format painter. Select A1 which contains the CF, click on format painter (brush icon). This copies the formatting. Then just select A1:A100 to paint/"paste" the formatting (inclusive the CF formatting) to the range. 2. Set and apply the CF to the range at one go (my preference) Select A1:A100 (A1 active), then apply the CF using "Formula is:" Condition 1: =B1=1 Format Red fill Condition 2: =B1=2 Format Yellow fill OK out -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Taylor" wrote: I want cell A1 to be the color red if B1=1 and yellow if B1=2. I have figured out how to do this with conditional formatting, but how do i fill the conditional formatting for A2-A100 without creating a conditional format for each a cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Filling | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
filling information from one cell and filling another. | Excel Worksheet Functions |