Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight a row automatically if a cell meets certain criteria
I would like to know how to automatically highlight a row if one of the cells
in the row meets certain criteria. I have managed to highlight the cell with conditional formatting but would like to be able to highlight the entire row. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight a row automatically if a cell meets certain criteria
Apply conditional Formatting to all cells of the row, with a formula like
=C10="testvalue" HTH -- AP "simonvrowley" a écrit dans le message de ... I would like to know how to automatically highlight a row if one of the cells in the row meets certain criteria. I have managed to highlight the cell with conditional formatting but would like to be able to highlight the entire row. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight a row automatically if a cell meets certain criteria
Hi Simon,
Select the rows you want conditional formatting to apply to, then in conditional formatting enter this formula (suppose the condition is: cell value in column A = "condvalue"): =INDIRECT("A"&ROW())="condvalue" and choose a format! Replace ="condvalue" to your real condition, or post it to compose the formula! Regards, Stefi €žsimonvrowley€ ezt Ã*rta: I would like to know how to automatically highlight a row if one of the cells in the row meets certain criteria. I have managed to highlight the cell with conditional formatting but would like to be able to highlight the entire row. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight a row automatically if a cell meets certain criteria
Sorry: my solution did not answer the question!
-- AP "simonvrowley" a écrit dans le message de ... I would like to know how to automatically highlight a row if one of the cells in the row meets certain criteria. I have managed to highlight the cell with conditional formatting but would like to be able to highlight the entire row. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight a row automatically if a cell meets certain criteria
Hi,
When u apply Conditional Formatting to a single cell, this means only that single cell will be formatted when criteria returns the answer as TRUE. Try applying your Conditional Formatting to all the other cells in the range as well. Don't forget to lock the reference cell by preceeding the cell address (ie. column or row) with the $ sign (example $A1 will ensure all the cells in the same row will refer to column A). Sample: 1 .Open a new blank sheet & select range A1:D10 2. Conditional Formatting : Formula is =$A1="OK" 3. Then type "OK" in any cell betwen A1:A10 You should be able to see the effect of your conditional formatting whenever Ok is entered into any cell in A1:A10 Hope this helps. -- Edmund (Using Excel XP) "simonvrowley" wrote: I would like to know how to automatically highlight a row if one of the cells in the row meets certain criteria. I have managed to highlight the cell with conditional formatting but would like to be able to highlight the entire row. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight a row automatically if a cell meets certain criteria
Apply the conditional formatting to all the cells in the row
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I automatically fill a cell based on another cell in Excel | Excel Discussion (Misc queries) | |||
How can I automatically highlight a cell that has changed value | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
"criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) |