mjg060468
01-25-2010, 09:09 AM
Hi need help.
Have a spreadsheet that requires a range of cells to change colour based on the numbers entered. eg. b2:g2 against the targets entered in b1:g1
If the number entered in b2 is <50% of b1 then cell is red
If number entered in b2 is >=50%<=75% of b1 then cell is orange
If number entered in b2 is >75% of b1 then cell is green.
If blank then cell is white
This will then need to be copied across range of cells eg b2:g2
Can anyone help me, please!:help
Have a spreadsheet that requires a range of cells to change colour based on the numbers entered. eg. b2:g2 against the targets entered in b1:g1
If the number entered in b2 is <50% of b1 then cell is red
If number entered in b2 is >=50%<=75% of b1 then cell is orange
If number entered in b2 is >75% of b1 then cell is green.
If blank then cell is white
This will then need to be copied across range of cells eg b2:g2
Can anyone help me, please!:help