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!
- 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
- How to delete cells in word - Guide
- What function can automatically return the value in cell c77 - Excel Forum
- Based on the values in cells b77 b81 what function can automatically return the value in cell c77 ✓ - Excel Forum
- Excel add 1 if cell contains text ✓ - 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