Pls find attached file ...and pls help
Pls find attached file ...and pls help
You can use conditional formatting
1. Select cell b4
2. Choose Format->Conditional Formatting...
3. Choose
Cell Value Is
Greater than
=$O$4-SUM($B$4:B$4)+B$4
4. Click the format button and set the color to red
5. Click ok
6. Use the format painter to copy this format to the rest of the row
Thank you very much for the reply.
But I have many such rows to which I want to use same criteria and tried to format painter to copy the conditional formating to other rows too .but it is not working .pls help me to copy the conditonal formatting to other rows.
Assuming you want the same formula to change for each row if you copy it down
Choose format, conditional formating formula is and put
=SUM($B4:B4)>$O4
in cell B4
this can be format pasted, or copy, paste special formats to all the other cells
Regards
Dav
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks