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
Hi Linda A. Barnes , I don't know if it's the forum software, but it's really hard to read that description because there is no punctuation and no new lines, so I re-wrote it as a bullet list, but I'm not sure I got it right.
- 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.
To colour a whole row when a single cell in the row has a specific value, you need to do this:
- Select all rows you want to apply the format to, making sure the current cell is in your first row of data, i.e. row 2
- create a new rule using a formula
- use a formula along these lines
=$A2="something"
- select a fill colour for that rule
The important bit here is the $ sign before the column letter. This will ensure that only that column is checked for the condition.
Create a rule for each colour. Change the order in which the rules are applied in the Rules Manager dialog and use the "Stop if True" tick box to manage which rules will override other rules.
With so many different columns having conditions, it may be a bit tricky, so play with the order of the rules until things are looking all right.
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.
