abdelfattah
Well-known Member
- Joined
- May 3, 2019
- Messages
- 1,429
- Office Version
- 2019
- 2010
- Platform
- Windows
hello
I need macro to draw red oval based on multiple condition the range in columns a,b,c,d,e should draw for words and values (abc,fired, <50) and if is more than column contain oval then write in column f closed (bold, red font )
this is what I expected
I insert oval around cell but when I insert image not show you can depend on my explanation above
thanks in advance
I need macro to draw red oval based on multiple condition the range in columns a,b,c,d,e should draw for words and values (abc,fired, <50) and if is more than column contain oval then write in column f closed (bold, red font )
this is what I expected
SHAPE.xlsm | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | name | case1 | case2 | case3 | case4 | FINAL | ||
2 | Ali | 20 | 54 | abs | fired | CLOSED | ||
3 | Omar | 40 | 73 | pre | existed | |||
4 | Ahmed | 50 | 34 | abs | existed | CLOSED | ||
5 | Mahmoud | 60 | 22 | abs | fired | CLOSED | ||
SS |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A1:A7,A10:A1048576 | Cell Value | duplicates | text | NO |
I insert oval around cell but when I insert image not show you can depend on my explanation above
thanks in advance