Search : in
By :

Excel Conditional Cell Formatting

Last answer on Oct 23, 2009 10:10:39 am BST Nancy, on Oct 11, 2009 10:52:49 pm BST 
 Report this message to moderators

Hello,

I need an MS Office Excel 2007 formula. I want to fill multiple cells in a row with color IF one particular cell in the row is divisible by 5. The particular cell with the number in it contains a formula (example: =$C$1-C65)

Thanks for any help you can give.

Nancy

Configuration: Windows Vista
Firefox 3.0.10

Best answers for « Excel Conditional Cell Formatting » in :
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Unlimited Conditional Formatting ShowUnlimited Conditional Formatting Introduction Principle Code Introduction The limitation of MFC (Conditional Formatting) to Excel version 2007 is less than 3. This is very short. Having seen many applications to push the limit, I am...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Download DBF To XLS Converter ShowThis is a very useful software that will allow anyone to convert DBF files into Excel's .xls format files. Features: The user interface of the converter is very simple to comprehend and almost anyone can do it within some simple clicks. All...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Ask your question Reply

1

venkat1926, on Oct 12, 2009 4:25:23 am BST

The cdoe will be something like this (modify to suit you) 

Sub test()
Dim r As Range, c As Range
Set r = Range("c1:c65")
For Each c In r

If c Mod 5 = 0 Then c.EntireRow.Interior.ColorIndex = 3
Next c

End Sub

   
Reply to venkat1926

2

Nancy, on Oct 12, 2009 1:30:58 pm BST

Thank you for your reply. It is still way over my head, though. Would it be possible to dumb it down? What, exactly, would I put in the cell? Where do I enter the formula? Where do I set the range?

Thanks...

   
Reply to Nancy

3

 Aphelion, on Oct 23, 2009 10:10:39 am BST
  • +1

The script above is actually a VBA script.
Access VBA by using ALT+F11 while in Excel.

   
Reply to Aphelion
Ask your question Reply
They need your help