If the result in cell (o21)> or = 32%, I need the adjacent cell (p21) to display a red "X"
but if the result is less than 32%, I need (p21) to display a green check mark. Thoughts appreciated.
If the result in cell (o21)> or = 32%, I need the adjacent cell (p21) to display a red "X"
but if the result is less than 32%, I need (p21) to display a green check mark. Thoughts appreciated.
Hi,
Do not mind but try to upload workbook always so that the user will reply faster.....
Please upload the workbook with the required output......
Lokesh Kumar
Stay Hungry.. Stay Foolish..
_________________________________________________________
Please Click STAR to Add Reputation if my/someone's answer helped!
There are four stages to this
1. Set the font format of P21 to WingDings
2. Put this formula into P21Formula:Please Login or Register to view this content.
3. Select P21 and then conditional formatting via formula. use this formula =O21<32 then select format, Font and set the font format to red
4. Select P21 and then conditional formatting via formula. use this formula =O21>=32 then select format, Font and set the font format to Green.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks