Conditional Formatting - Highlighting lines after text is entred
I have a condifional format below that highlights the row when text is entred into the cells specified.
What i was hoping for to go along with this is a new formular thats the same process of highlighting the row but when 'Yes' is entred into cell G5, is this possable?HTML Code:
If you need anything explaining, please let me know!
Regards,
Last edited by snoopy1461; 03-14-2012 at 06:49 AM.
Hi
Do you mean to keep the formula that you use and add, one more condition(=G5-"Yes")??
Last edited by Fotis1991; 03-14-2012 at 06:55 AM.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
So that condition 1 will be if cell G5 says Yes then it fomats the cells
and condition 2 my original formular above?
Yes. I think you can do it. First Condition is $G$5="Yes"
Second condition= Your formula.
Thanks for this, it has worked as i wanted it to!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks