Hi i am creating a type of time sheet but i need help i want cells c5 to i5 to change colour to green automatically when i put just a Y in k5
can anyone help please thanks
Hi i am creating a type of time sheet but i need help i want cells c5 to i5 to change colour to green automatically when i put just a Y in k5
can anyone help please thanks
Select cells you want to format (C5:I5) and in Conditional Formatting use rule: =$K5="Y"
Last edited by zbor; 10-07-2012 at 04:36 AM.
works a treat thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks