Conditional Formatting
Solved/Closed
tareqnaser95
Posts
1
Registration date
Tuesday September 9, 2014
Status
Member
Last seen
September 9, 2014
-
Sep 9, 2014 at 12:36 PM
Osama_bb11 Posts 22 Registration date Sunday May 25, 2014 Status Member Last seen September 25, 2014 - Sep 10, 2014 at 02:25 PM
Osama_bb11 Posts 22 Registration date Sunday May 25, 2014 Status Member Last seen September 25, 2014 - Sep 10, 2014 at 02:25 PM
Related:
- Conditional Formatting
- Excel formula to change cell color without conditional formatting - Excel Forum
- Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Copy conditional formatting but change reference cell ✓ - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 10, 2014 at 02:20 AM
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
Posts
22
Registration date
Sunday May 25, 2014
Status
Member
Last seen
September 25, 2014
Sep 10, 2014 at 02:25 PM
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
