Is there a way to have a formula highlight/fill the boxes based on criteria entered? I know this is doable with conditions, however I am finding myself making 3 conditions for each column and its a heavy sheet with many columns. There has to be an easier way?
What we are looking to do, is enter in data (The total #'s Manually), example shown below. and we would love if the sheet would automatically assign them a "fill" color based on the value we enter, My example of the table below is currently using the conditions set.. but I would love to apply a formula to the whole sheet, or each column as a formula.
Turn Red if between 0 and 720
Turn Yellow if 720 to 1439
Turn Green if 1440 to 10000.
Any and all help is welcome!! :) Thank you!
