Microsoft 365
Hi,
I have googled this to death and haven't found a solution. Might be I am not searching with the right terminology. Forum search comes up with a number of results but all the thread posts are blank.
I have a table within word and have added a field with a formula that calculates the percentage X/Y*100 = X%
What I would like to do is, if that percentage is 100% its green and if its less then 100% make it red.
Is this even possible in word with or without a VBA?
The blank threads are not blank - there's a little bug, I'm afraid - just hit refresh in your browser and all the text will appear.
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.
Awesome, thank you.. refresh worked.
Last edited by AliGW; 08-30-2023 at 01:38 AM. Reason: Please do NOT quote unnecessarily! Use the QUICK REPLY button instead.
Not really Conditional Formatting and requires VBA. But it should be able to be adapted to meet your requirements.
See: https://answers.microsoft.com/en-us/...6-99410a7fb02d
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Please Google: conditional formatting of table values in word for more ideas and suggestions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks