conditional formatting...

[ibmman]

Hello I'm trying to delete cells that I had conditionally formmatted in excel.. I tried using conditional select in ASAP utilities but evidently regular formatting is different than conditional formatting therefore conditional select wont select them... otherwise ill have to search for and delete about 900 numbers manually and that wont be fun... what i have is about 900 rows of numbers, and theres a max value function that displays the max value for each row, i had used conditional formmating to use that result of the max value function and fomat the cells the max values are contained in, in each row... now i want to delete them.... :wink:

 

[Mark W.]

Use Edit | Go To... [ Special... ] Conditional formats

 

[Andrew Poulsom]

Have you tried Edit|Go To|Special|Conditional Formats?

 

[ibmman]

that didnt do anything useful.. it selected the entire regon in which the conditionally formatted cells are, not the individual cells.....

 

[ibmman]

all the cells are conditionally formatted... i need to select the cells that meet the condition and show up in this case red