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 reply

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

0