Hi. I would like to know if I can format a whole sheet easily.
If the value in the cells column 1-6 is below the value in Target it needs to go red, = to needs to be amber and above needs to be green. I can do it a column or row at a time but not sure how to do it for a whole sheet where each row compares it to a different target in column A.
Can anyone help me please!!
Bookmarks