Hi,
conditional formatting need to be applied on one column based on satifying some conditions on another column.. is it possible ?
For example, If I have a pupil list of a school & their marks.
Their marks should be highlighted, if their standard is 8th.
means,,,all 8 std students marks should be highlighted...
I am sure some one can help me on this forum..
Regards
Mani
Select the list of names and go to Format|Conditional Formatting...
Then select Formula Is
and enter formula like: =B1="8th"
or =B1=8 (if you have just a number in there).
where B1 is the top most cell corresponding to top most cell you selected to highlite.
Then click Format and choose colour from pattern tab.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thank you. it works great
will it be possible to have multiple conditions to satisfy conditional formatting ?
Like all John in Class 8 should be highlighted ?
use something likeLike all John in Class 8 should be highlighted ?
=AND(B1="8th",C1="John")
where column C holds the pupil name
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks