excel help with formula or something

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.