Forum Discussion
anupambit1797
Mar 10, 2023Iron Contributor
Replace function
Dear Experts, I have a situation , where I want to replace the integers within the red-box with a Text = Even/Odd, so 0 shall be replaced by Even, 1 shall be replaced by Odd, any ...
- Mar 10, 2023
In A5, enter the formula =IF(ISODD(A1),"Odd","Even")
Fill to the right to L5, then fill down to row 7.
With A5:L7 still selected, copy the range (click Copy on the Home tab of the ribbon or press Ctrl+C).
Select A1, then click the lower half of the Paste button on the Home tab of the ribbon and select Values.
You can now clear A5:L7.
anupambit1797
Iron Contributor
Sorry , I am not much comfortable with VBA 😞
HansVogelaar
Mar 10, 2023MVP
Try mtarler's suggestion.
- HansVogelaarMar 17, 2023MVP
Instead of changing the fill colorpattern, set the number format in the conditional formatting rules.
- anupambit1797Mar 17, 2023Iron Contributor
Thanks HansVogelaar , mtarler , I tried to use the suggestion , I could reach till here, but not sure how to edit the one encircled with Red, with Odd and Even text..
Can you please elaborate more.
Thanks ,
Br,
Anupam
- anupambit1797Mar 19, 2023Iron ContributorThank you very much hans 🙂