Hello..
I have been trying to color code the cell based on the cell value. if the cell value is Contra Font color should be in red and if its Opex should be in Green. I have tried something to do but seems like its not working as expected.
Attached is the sample sheet for reference. I dont wanna use Conditional Formatting here. just Custom formatting or next Text function with in IF statement.
Thanks,
Sri
Last edited by Sri.n; 05-16-2022 at 03:25 AM.
If you don't want to use CF (which is the tool designed for this), then this cannot be done without VBA - shall I move your thread for you?
Last edited by AliGW; 05-13-2022 at 12:18 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi Ali, I was thinking if we can use the Custom formatting or Text function nested in IF condition. If my thought is wrong pls move the thread.
You cannot control text formatting using the TEXT function - formulae and functions cannot read or write formatting to a cell.
In the workbook, you have not shown what you want, but the tool that does what you seem to be describing is conditional formatting - that is what it is for.
Before I move the thread, show us what you want.
Hi Ali,
this is my requirement. I have attached the file with expected output.
In Cell G3, IF Value of F3 is more than 5m then its should show as Contra with Font Color/Fill cell as Green, if that’s not show as Opex in Red
OK - thanks. This confirms my understanding.
Custom text formatting can work only on the cell it's applied to and not refer to an adjacent cell.
You have only one option: VBA.
Pls Try Cell G2 formula , Drag down
Formula:
Please Login or Register to view this content.
The active sheet places the code as below
Please Login or Register to view this content.
Thanks you everyone for helping out..
@Sri.n You're Welcome. Glad to help . Thank You for the feedback and for marking the thread as 'Solved'.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Last edited by wk9128; 05-13-2022 at 02:09 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks