Is there a way I can do a rule or something in the conditional formatting to add a background color for the highest number without typing the number?
For example, Right now Im doing "greather than > 20" because right now the highest is over 20 but if any of the other go over 20 then they will get a background color and I dont want that. and If I do the range then it shows like the middle one and I want only the top one to get highlighted. Maybe an IF statement ike (IF[ProjectITStaff]=MAXVALUE,1,2) I could use the 1 and 2 in the conditional formatting as stable numbers. I can't figure out the IF statement