Hi everyone,

I have a task to create something in excel that would enable a change in a field of a column to reflect on another field in another column such that;

If field1 is blank, then field 2 should be red. And if difference between field1 and field3 is equal or greater than 7 then field2 should turn red, else green.

Please can someone HELP ME. am stuck. I don't mind if i could have the query or calculated expression for it. Thanks

Hi,

You can do this with conditional formatting. The exact instructions will depend on your version of Excel?