IF= CHANGE THE COLOUR OF THE LINE ? [Closed]

Report
-
mubashir aziz
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
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 reply

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
210
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 .....