Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting an entire row based on one cell
If the value in Column 6 of a specific row is equal to 1, I would like to
highlight that entire row... I'm having trouble with the "row" function of the formula. Any ideas? -c |
#2
|
|||
|
|||
Will this work:
Highlight the applicable columns, choose Conditional Formatting, select 'Formula Is' and enter =countif($F1,1)=1 and choose a color. This should highlight the applicable row if the cell in column F has 1 in it. "colettey29" wrote: If the value in Column 6 of a specific row is equal to 1, I would like to highlight that entire row... I'm having trouble with the "row" function of the formula. Any ideas? -c |
#3
|
|||
|
|||
Perhaps this would also work as well ..
Press CTRL+A to select the entire sheet (the initial selection step is important in CF) Click Fornat Conditional Formatting Under Condition1 Formula Is | =$F1=1 (note the "$" sign above) Click Format Patterns tab Gray? OK Click OK at the main dialog Now test it out by inputting 1's within any/several cells in col F, and the entire row(s) will be filled gray .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "colettey29" wrote in message ... If the value in Column 6 of a specific row is equal to 1, I would like to highlight that entire row... I'm having trouble with the "row" function of the formula. Any ideas? -c |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
How can I assign a range starting cell based on a variable locati. | Excel Discussion (Misc queries) | |||
Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
Modify Row based upon cell value | Excel Worksheet Functions |