Conditional formatting comparing two columns
I have data validation going on in column B, which doesn't allow me to use
small numbers, so I added two columns to the table and did as you suggested.
The result was that all three cells were highlighted. Then, I added 4,5,6 to
three other cells in the first column (in this case, M) and 6,5,4 in the
adjoining cells in the second column (N). I used =N1M1. The result was that
the, in column N, containing 5 was highlighted.
I think there is something wrong with the table. I am working on a class
assignment and the table was created by the teacher, so I don't know what
might be going on there.
--
Shelina
"Jacob Skaria" wrote:
--Make sure your selection is Range F1:F10. Please note that the cell
reference F1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection..
--Copy paste the below formula
=AND(COUNT(F1,B1)=2,F1B1)
--Enter 1 in cell B1 and 2 in cell F1 (f1 should be highlighted)
--Enter 2 in cell B2 and 3 in cell F2 (f2 should be highlighted)
--Enter 2 in cell B3 and 1 in cell F3 (f3 will not be highlighted)
If this post helps click Yes
---------------
Jacob Skaria
"Shelina" wrote:
Thanks for your help.
I am using 2007. I did as you suggested and random cells were highlighted,
non of them were examples of =F1B1. I tested =B1F1 and the resulting
highlighted cells were all the cells which were not highlighted in =F1B1. Do
you have any idea what might be happening there?
--
Shelina
"Jacob Skaria" wrote:
1. Select the cell/Range (say F1:F10). Please note that the cell reference F1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection..
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=F1B1
'To handle blank entries you can try the below formula
=AND(COUNT(F1,B1)=2,F1B1)
4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK
PS: If you are using Excel 2007 Goto Home tabStylesConditional
FormattingManage rulesNew ruleUse a formula to determine which cells to
format
If this post helps click Yes
---------------
Jacob Skaria
"Shelina" wrote:
Help! I need to create conditional formatting that highlights a cell, if the
value in column F is greater than the value in column B. How do I make that
work? Thanks!
--
Shelina
|