Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formattion for whole row based on one cell value
Hi,
I am using Excel 2007. I need to use Conditional formating for whole row based on one cell value. If cell value is more then 25, cell colour formatting should be applied to whole row. Can some one pl explain me how to acheive it? Thanks in anticipation. Regards, Madiya |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formattion for whole row based on one cell value
Hi,
Select your row and use this conditional format formula =$A125 Pick a colour. Mike "Madiya" wrote: Hi, I am using Excel 2007. I need to use Conditional formating for whole row based on one cell value. If cell value is more then 25, cell colour formatting should be applied to whole row. Can some one pl explain me how to acheive it? Thanks in anticipation. Regards, Madiya |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formattion for whole row based on one cell value
It works because the $ before the column letter keeps the reference to column
A when Excel applies the formula to other cells in the row... If you paint the same over second row it will refer to A2... "Mike H" wrote: Hi, Select your row and use this conditional format formula =$A125 Pick a colour. Mike "Madiya" wrote: Hi, I am using Excel 2007. I need to use Conditional formating for whole row based on one cell value. If cell value is more then 25, cell colour formatting should be applied to whole row. Can some one pl explain me how to acheive it? Thanks in anticipation. Regards, Madiya |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formattion for whole row based on one cell value
On May 30, 9:16*pm, Sheeloo wrote:
It works because the $ before the column letter keeps the reference to column A when Excel applies the formula to other cells in the row... If you paint the same over second row it will refer to A2... "Mike H" wrote: Hi, Select your row and use this conditional format formula =$A125 Pick a colour. Mike "Madiya" wrote: Hi, I am using Excel 2007. I need to use Conditional formating for whole row based on one cell value. If cell value is more then 25, cell colour formatting should be applied to whole row. Can some one pl explain me how to acheive it? Thanks in anticipation. Regards, Madiya- Hide quoted text - - Show quoted text - Mike & Sheeloo, Thanks. This works like charm. Regards, Madiya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - For 1 cell based on contents of any cell | Excel Discussion (Misc queries) | |||
Conditional formatting Based on cell A text with conditions in Cell B | Excel Discussion (Misc queries) | |||
conditional formatting one cell based on content of another cell | Excel Discussion (Misc queries) | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) |