Is there a way to set a conditional formatting for a change in the number for example one cell A1 has 100 B1 50 C1 100. So the 100 would be green but the 50 would be red because there was a change in score which was a decrease.

Select the range starting in B1 and try =A$1>B$1 for the red condition and =A$1<=B$1 for the green condition

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I have attached a sample file. Is this a possible way to set it up?

Attached Files

Book1.xls (17.5 KB, 17 views)

No
all you need to do is follow post #2, without adding anything. XL will take care of th rest

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Sorry but I am confused...aren't I adding in the formula you gave me in post 2 in the conditional formatting as a new rule?

Thank you for your help.

Is the attached what you need?

Attached Files

Book1(1).xls (25.0 KB, 13 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Yes thank you. I had the formula but starting in Cell a not B.

Thank you. This work...but I am trying to apply it to more than one row. I will eventually have about 40 rows. I tried applying it past the first row and it is not working.

Thats is because I assumed ther was only one row.
Just remove the $ signs from the formula and then change the range(where you have to keep the $ signs of course) You do not have to create a CF row by row !

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you for all your help. Really appreciate it.

I have one more thing to add....if there is no number in the field to report...is there a way to record 0 as a white cell? Not red or green.

You could add a condition like =A1=0 applied to the range and formatted as " no fill".
Just make sure that condition is the las of the three ( use the arrows in the CF Rules manager to end it to the last place

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post