Conditional formatting in excel 2007
Solved/Closed
Related:
- Conditional formatting in excel 2007
- Save as pdf office 2007 - Download - Other
- Excel date format dd.mm.yyyy - Guide
- Excel formula to change cell color without conditional formatting - Excel Forum
- How to clear formatting in excel - Guide
- Screenshot in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 9, 2011 at 03:41 PM
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<>" - "))
you need to do some thing like this
=AND($A1<>$B1,OR($A1<>"",$B1<>""),AND($A1<>" - ",$B1<>" - "))
Feb 9, 2011 at 04:01 PM
Your help is really appreciated.
Feb 9, 2011 at 04:05 PM
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
Feb 9, 2011 at 04:24 PM
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.
Feb 9, 2011 at 04:32 PM
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
Feb 9, 2011 at 06:24 PM
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