Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
I have a table of data that contains both numeric and non-numeric data. I am trying to use conditional formatting to highlight all entries with numeric data > a limit, but the non-numeric data is highlighted also. Is there a way to do this to filter out the non-numeric data and only change the background for cells with values > limit? Thanks
Summary: Is there a way to set up conditional formating to format a cell if another cell meets a certain criteria? ie. if "cell a" > 150 then highlight "cell b" else do nothing. your help is m...
Summary: Unless you aren't telling us the whole the story, you don't need a macro to do this. This can be done with Conditional Formatting. Conditional formatting is limited to 3 conditions, so it should fit y...
Summary: Dear All, I have a small query on excel and conditional formatting. Here goes: I have a column that has all dates in them displayed as 02.08.2008 or 15.09.2008. My question is how do I format these ce...
