IF= CHANGE THE COLOUR OF THE LINE ?

Closed
hchwhy - 14 Jul 2009 à 14:14
mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 - 15 Jul 2009 à 01:27
Hello,
I'm having a bit of trouble, what i need is if a box says yes the whole line that its on goes red and if it says no then the line goes green. I really dont know what to write here but you're help is much appreciated and by the way im on office 2007
Thank you very much xx

1 response

mubashir aziz Posts 190 Registration date Sunday 12 April 2009 Status Member Last seen 16 February 2010 166
15 Jul 2009 à 01:27
This is because of using Conditional Formatting. you can just explore it thru excel help ......

suppose your data in A1 then in Conditional Formatting you can write Formula is A1="Yes" and apply the format .....