The number filled in column C will turn red if it is lower or higher than column B
Any help would be appreciated!
The number filled in column C will turn red if it is lower or higher than column B
Any help would be appreciated!
Last edited by metrostar; 11-20-2022 at 08:05 AM.
This is the CF rule for C2:
=LET(t,MID(A2,2,99),OR(C2<B2-t,C2>B2+t))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you AliGW , You are amazing
You're welcome.
Select the C2:C10 area, conditional formatting to place the formula
Formula:Please Login or Register to view this content.
Text color font selection red
Thank you wk9128 , You are amazing
@metrostar You're Welcome. Glad to help . Thank You for the feedback and rep.
Or try CF-ruleFormula:Please Login or Register to view this content.
What you get is a text number, so it can't correspond to the formula, just change it to this
^ 1 or 2 , the result is a bit different
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks