Hello,
In the attached workbook I am trying to format cells in column A if the letter F appears anywhere in the row. I'm not really sure how to describe it but I would want the format on cells A1,A2 and A5 as he letter F appears on those rows.
Hope that makes sense.
Dean
Last edited by Dean81; 03-20-2012 at 12:21 PM. Reason: SOLVED
you can do this with the following formula, example attached
=COUNTIF($B1:$H1,"F")>0
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
Select all the cells in column A, starting with A1 (the active cell), then click on Conditional Formatting | New Rule | Use a formula ... etc., and then enter this formula in the box:
=COUNTIF(1:1,"f")>0
then set up the format that you want (foreground colour, background colour [fill] etc) and then OK your way out. The cell references will automatically adjust to suit the other rows.
Hope this helps.
Pete
That's great. Thanks very much. Just out of interest, if I wanted it to be anything between F and H rather than just F or say, anything greater than F, how would I do that?
Dean
You could do it like this:
=COUNTIF($B1:$H1,">=F")=0
of ir you wanted to do inbetween a range you could use countifs like this
=COUNTIFS($B1:$H1,">=F",$B1:$H1,"<=G")=0
Thanks very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks