Highlighting cells in one column from a formula valuein another co

  • Thread starter Thread starter Brian H
  • Start date Start date
B

Brian H

I want to highlight any cells in column A (Cutomer Name) when the If formula
(=IF(EM26>EN26,"Short DataPac's","Config is OK") in the cells from column EO
return a formula value of "Short DataPac's"
 
It sounds like using the Data/Filter/Autofilter command on your data,
and then selecting Short DataPacs from the resultant list box at the
top of EO will give you what you want. This process will hide all the
rows that do not match what you have selected. When finished,
selecting the None option in the list box at the top of EO will
redisplay all of your other data.
 
cursor in cell a1
from the menu
Format -> Conditional Formating
Dropdown box -> "Formula is"
enter =EO1="Short DataPac's"
 
Sorry, I'm a new poster and did not state the MS version. I tried this in
both Excel 2003 and 2007. I use 2007 all the time now. In 2003 version, I
could get cell A to change the font to another color, but could not get the
cell to highlight with a color. Also I need to copy this function to
highlight any cell in column A if the corrosponding cell value in column EO
reports the false statement of "Short DataPac's". (=IF(EM26>EN26,"Short
DataPac's","Config is OK"))
 
Thanks, this will sorta work. I did not want to hide any data though, just
highlight any cell in column A where the cell formula value in EO states the
False Value. This is a complex report and I do not use column headings.
 
Back
Top