Macro comparing two columns
Closed
RoundOrange
Posts
1
Registration date
Monday May 25, 2009
Status
Member
Last seen
May 26, 2009
-
May 26, 2009 at 03:58 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 28, 2009 at 04:43 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 28, 2009 at 04:43 AM
Related:
- Macro comparing two columns
- Spell number in excel without macro - Guide
- Display two columns in data validation list but return only one - Guide
- Macro excel download - Download - Spreadsheets
- Automatically run a macro when opening a worksheet - Guide
- Excel macro to create new sheet based on value in cells - Guide
3 responses
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
165
May 28, 2009 at 02:00 AM
May 28, 2009 at 02:00 AM
Do you mean to say that both adjacent cells in column A & B > 0.1 turn B Red ????? Mean if and(A1>.01,B1>.01) then make cell B1 Red . if any of the condition if false then do nothing ..... Even if they are equal then will not work ....
simply put this formula in Conditional Formatting =AND(A1>0.01,B1>0.01). Make sure you are in Cell B1 .... if you want to apply whole column then select first Cell in B column and by pressing Shit or any method selected the last select of B and apply this formula =AND(A1>0.01,B1>0.01)
simply put this formula in Conditional Formatting =AND(A1>0.01,B1>0.01). Make sure you are in Cell B1 .... if you want to apply whole column then select first Cell in B column and by pressing Shit or any method selected the last select of B and apply this formula =AND(A1>0.01,B1>0.01)
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
May 28, 2009 at 02:31 AM
May 28, 2009 at 02:31 AM
Hi
Instead of a macro, try conditional formatting
Select cell B1 and apply conditional formatting with formula =and(A1="Lead",B1 > .01) and color formatting to Red
Do let me know If it helps...
Instead of a macro, try conditional formatting
Select cell B1 and apply conditional formatting with formula =and(A1="Lead",B1 > .01) and color formatting to Red
Do let me know If it helps...
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
165
May 28, 2009 at 04:43 AM
May 28, 2009 at 04:43 AM
Sorry my mistake just replace the >.01 in A1 with ="lead"
and(A1>.01,B1>.01)
=AND(A1="Lead",B1 > .01)
and(A1>.01,B1>.01)
=AND(A1="Lead",B1 > .01)
