Macro for coloring cells according to the value of the cell!
Closed
PeriGr
Posts
11
Registration date
Monday July 17, 2017
Status
Member
Last seen
August 12, 2017
-
Jul 20, 2017 at 11:39 AM
Blocked Profile - Jul 20, 2017 at 04:32 PM
Blocked Profile - Jul 20, 2017 at 04:32 PM
Related:
- Macro for coloring cells according to the value of the cell!
- How to delete cells in word - Guide
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
- Excel arrow keys not moving cells - Guide
- Based on the values in cells b77 - Excel Forum
- Based on the values in cells b77:b81, which function can automatically return the value in cell c77 ✓ - Excel Forum
1 response
It is called Conditional Formatting, take a look here:
https://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color
https://ccm.net/forum/affich-910435-conditional-formating-formula-cell-text-change-color