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.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
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
Reply With Quote
Bookmarks