Conditional formatting in excel 2007

Solved/Closed

NS - Feb 9, 2011 at 03:31 PM
Toast - Feb 16, 2011 at 10:05 PM

Hello,
I am trying to apply conditional formatting to a calculated cell (For ex A).

Criteria: If Cell A value = Cell B or " - " then dont apply any conditional formatting. Else, highlight the cell in Red.

I thikn it is simple but for some reason i am not able to apply conditional formatting with this rule/formula. Please help ASAP.

Thx

Conditional formatting in excel 2007
Save as pdf office 2007 - Download - Other
Excel date format dd.mm.yyyy - Guide
How to clear formatting in excel - Guide
Number to words in excel - Guide
How to take screenshot in excel - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2011 at 03:41 PM

It would have helped had to posted your formula

you need to do some thing like this

=AND($A1<>$B1,OR($A1<>"",$B1<>""),AND($A1<>" - ",$B1<>" - "))

NS
Feb 9, 2011 at 04:01 PM

Thank you so much..it worked. Another question..is there a shortcut to apply this formula to column or rows without copy and pesting? I have like 20 rows and 6 columns..:(

Your help is really appreciated.

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2011 at 04:05 PM

Lets say you want to apply this rule to column A and B fully
then click of Cell A1 first
then select column A and B
go to conditional format and apply the formula for A1 cell
It will copy for next rows on its own. Basic idea is that first you select the first cell of the range, then select your range and finally you apply the format condition for that row or column (depends on what you want) but the first cell of the range

NS
Feb 9, 2011 at 04:24 PM

I selected E11 to K11 cells and applied formatting formula of... =AND($E$11<>$E$39,OR($E$11<>" - "))....

But it still shows same formula when i check formula for F11...instead it should be...... =AND($F$11<>$F$39,OR($F$11<>" - "))....

When i try removing $ sign; i.e ... =AND(E$11<>E$39,OR(E$11<>" - "))....it didnt work either.

Can you please advice. Thank you very much.

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2011 at 04:32 PM

Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.

Note: your data need not be to be real data but a good representative of how data looks like

NS
Feb 9, 2011 at 06:24 PM

Refer to link above.

Refer to cells E10 to K10 and M10 (exclude column L)..I have conditional formatting. I need to do that for the entire table. Second table below is where we are comparing the values by combination of column C and D. Hope this helps.

https://accounts.google.com/ServiceLogin?service=wise&passive=1209600&continue=https://docs.google.com/spreadsheets/d/1aCi-8zVevpYPCpKQeorJnbF4gXLNDsADvuyhwYFrIzk/edit?authkey%3DCM6jgPgG%26hl%3Den%26hl%3Den%26authkey%3DCM6jgPgG&followup=https://docs.google.com/spreadsheets/d/1aCi-8zVevpYPCpKQeorJnbF4gXLNDsADvuyhwYFrIzk/edit?authkey%3DCM6jgPgG%26hl%3Den%26hl%3Den%26authkey%3DCM6jgPgG<mpl=sheets&hl=en

Similar discussions

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

How to calculate positions (1st,2nd,3rd...) in Excel

Similar discussions

Subscribe To Our Newsletter!