Conditional Formatting
Solved/Closed
tareqnaser95
Osama_bb11
- Posts
- 1
- Registration date
- Tuesday September 9, 2014
- Status
- Member
- Last seen
- September 9, 2014
Osama_bb11
- Posts
- 22
- Registration date
- Sunday May 25, 2014
- Status
- Member
- Last seen
- September 25, 2014
Related:
- Conditional Formatting
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
- Conditional formatting excel if another cell contains text ✓ - Forum - Excel
- Conditional formatting if another cell is blank - Forum - Excel
- If cell contains date then conditional format - Guide
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
2 replies
venkat1926
Sep 10, 2014 at 02:20 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Sep 10, 2014 at 02:20 AM
try this macro
Sub test()
Dim r As Range, c As Range
Worksheets("sheet1").Activate
Set r = Range(Range("A1"), Range("A1").End(xlDown))
For Each c In r
If c >= c.Offset(0, 1) Then c.Interior.ColorIndex = 3
Next c
End Sub
Osama_bb11
Sep 10, 2014 at 02:25 PM
- Posts
- 22
- Registration date
- Sunday May 25, 2014
- Status
- Member
- Last seen
- September 25, 2014
Sep 10, 2014 at 02:25 PM
Hi
also you can add conditional format to column A
1-select the cellA1
2-conditional formatting --> new rule
3-format only cells that contains ..
4- Cell vale ---less than---$b$1 ( remove $ ) $B1
5-format ( the way you like )
use format painter to copy the A1 format to al1 A column
also you can add conditional format to column A
1-select the cellA1
2-conditional formatting --> new rule
3-format only cells that contains ..
4- Cell vale ---less than---$b$1 ( remove $ ) $B1
5-format ( the way you like )
use format painter to copy the A1 format to al1 A column