Hello!
I have two columns, one with estimated values (J4:J130), and one with actual values(K4:K130). What I want to do is change the font colour of the actual values if they are less than 90% of the estimated values. Ideally the actual values would become red and remain black if they are 90% or above.
Thanks!
you can do this with conditional formating, just click on your cell, then go to Conditional Formating -> New Rule -> Format only cells that contain, then set the second dropdown to Less Than, and enter .9 in the next box.
next click on Format and set your formating options.
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.
Trying this right now..
I'm a bit confused, at what point would I select the other cell whose value the first cell needs to be 90% or greater of?
oh sorry i misread this... ok let me try this again. highlight K4:K130, then do add rule, and use formula, enter this formula
=(K4/J4)<.9
Hooray! Thank you so much!!
no problem, ill try to be more careful reading now
could you please mark this thread as solved?
problem solved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks