Set Cell Color based on a formula
I am looking for a method to set the color of a cell based on where the cell value originated from:
i have this formula: =if(a8-b8)>0, c8,d8) and values coming from C column should be blue and values from D column should be pink.
how do i do that please?
see attached spreadsheet
thank you for your help
you should be able to use the same sort of formula in a conditional format
=(a8-b8)>0
set to Blue
=(a8-b8)<=0
set to pink
see attached
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi Etaf, Thank you. That works
one more question please: is there a function to actually "set" the color of a cell please like =XXX(A1, BBB,CCC) where XXX is the function name, BBB the cell attribute (here color) and CCC the value that sets teh attribute here CCC could be a number/text value for blue and pink
No, there is no way, through just formulas to set cell formatting like bold, superscript, font color, background, underlines, etc. You need to work through Conditional Formatting or VBA
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you for your kind answer.
glad its worked Ok for you
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks