| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
APPLY CONDITIONAL FORMATTING TO A ROW IN EXCEL
Hi Gayathry
You can do this by using the following. I shall try to apply the format if A1 = 50. Select the entire row. Go to conditional formatting In the dropdown use Formula is and put in this formula =$A2=50. Then Select the format and click OK. If A1 = 50 the format would apply for the entire row and vice versa. I hope the said solves your problem Regards Raj "GAYATHRY" wrote: I NEED TO APPLY FORMATTING TO AN ENTIRE ROW WHEN ONE CELL IN THE ROW MEETS A CRITERIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, can Boolean logic be applied to conditional formatting? | Excel Worksheet Functions | |||
| Conditional formatting of a data series in an Excel Chart? | Excel Discussion (Misc queries) | |||
| How do I apply conditional formatting to a text box | Excel Worksheet Functions | |||
| EXCEL 2003: Apply Conditional Formatting to COLUMNS | Excel Worksheet Functions | |||
| how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
