IF= CHANGE THE COLOUR OF THE LINE ?

Closed
hchwhy - Jul 14, 2009 at 02:14 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jul 15, 2009 at 01:27 AM
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 April 12, 2009 Status Member Last seen February 16, 2010 165
Jul 15, 2009 at 01:27 AM
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 .....