View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Edmund
 
Posts: n/a
Default 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.