Forum Discussion
excel help with formula or something
Smitty SmithThanks for the link but it has not help. I am new to excel so maybe I am not doing it right
Hello Linda A. Barnes ,
the document that you shared in you question seems to be your original file with all your company data and links. I urge you to edit your question and remove that link. Then create a small sample file with just a few rows of dummy data and upload that here with the paper clip icon that shows below the reply box.
Explain the logic of what you want to achieve, e.g. "if cell A1 has the word "rhabarber" the whole row should turn orange" -- along these lines.
IngeborgHawighorst If column D is Y then row is light pink I can't recall my colour key I Column Q is y then row is light orange If Columm s has as a number whole row is light blue If Column T is has R light Blue (might just remove column S) column U with override everything if sold in the column with become light grey Column AF has n or no with be green I Y or yes then will be white no fill. I hope this helps if I can shown in a video I the first couple I can try for my self and change colours myself
Linda A. Barnes Can you be a bit more specific about what you're trying to accomplish? Feel free to upload an example workbook (no sensitive information) to OneDrive, and post a link back here, or post some screen shots of what you've got now, and what you'd like to do.
Smitty Smith https://1drv.ms/x/s!ApqQZFKwCI2m0w6FkiyQkP_VBZbM?e=flwT5u
I am trying to create a quick read by colour key but I can
the Pink to a light shade and Red to a lighter shade or tint
I would like the whole row hightened as you can see
I have manual format with fill to try to show you if you scroll the document. You will notice I have format with Dollar signs in the doc this is because I will be merging a word doc and I have also format 00001 this is the way I can identified the item in storage. I am hoping you can sell the headers match with the exception of Checked Y/N spelling and grammar it has the heading checked y/n. I hope you can understand what I am trying to achieve. This is for a fundraiser . so not a business.
