How can I sort data and still keep my Conditional Formatting?

Question

How can I sort my excel sheet and still keep my Rules?

Current Layout: Columns Needed: Infinite Rows Needed: A-G Currently

Locked Header A1-G1 Each labeled for different info. Example: A1 is Labeled "Discipline"

First Column Rules:

A2: =$A2="BCBA" Applies to: =$2:$1048576

A3: =$A3="OT" Applies to: =$3:$1048576

A4: =$A4="PT" Applies to: =$4:$1048576

A5: =$A5="PSYCH" Applies to: =$5:$1048576

A6: =$A6="SLP" Applies to: =$6:$1048576

A7: =$A7="SLPA" Applies to: $7:$1048576

A8: =$A8="SW" Applies to: =$8:$1048576

When I sort using A-Z or Z-A sort the rows lose their rule.

Goal: Be able to sort any column A-Z & Z-A but to have the rows follow the assigned rule in column A

I have done this in the past but for some reason this new excel sheet will not comply! :(

Answer 1

To it the same way, but apply the rules starting the first row.

Select A1

Open the CF manager

Change the range for each rule applied to =$1:$1048576

Your rules changes to

=$A1="BCBA" Applies to: =$1:$1048576

=$A1="OT" Applies to: =$1:$1048576

=$A1="PT" Applies to: =$1:$1048576

=$A1="PSYCH" Applies to: =$1:$1048576

=$A1="SLP" Applies to: =$1:$1048576

=$A1="SLPA" Applies to: $1:$1048576

=$A1="SW" Applies to: =$1:$1048576

Now you can sort the data any way you want.

Andreas.

Answer 2

I attempted to reply on the new post below but I could not.

thank you very much that was my issue exactly thank you very much!