Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Adelisa Fischer   on Feb 14 In MS Office Category.

  
Question Answered By: Mohammed Evans   on Feb 14

Are you searching a code in VBA or a function in Excel Worksheet?
If a code in VBA then in the Module copy this;

Sub CheckEntireRow()
Dim Counter as Integer
For Counter = 1 to 2^16
If Range("B" & Counter).Value2>100 then
Range("C" & Counter).Value2 = 1
Else
Range("C" & Counter).Value2 = 0
End If
End Sub

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Specifying conditional formatting for the entire row Or get search suggestion and latest updates.


Tagged: