Hello
Please how do I use formula in conditional formatting
If B4 is less than 50% as of today , then B4 turn Red.
I want today to be automatic.
Thanks
Hello
Please how do I use formula in conditional formatting
If B4 is less than 50% as of today , then B4 turn Red.
I want today to be automatic.
Thanks
I need a formaular in conditional formatting
Hi,
What have you tried the conditional Format. You can use the straighforward "cell value" "Less than" and enter 50%
Seems the today bit is irrelevant.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
is Today had any relation with value in B2?
if not use this =B2<50%
Punnam
I couldn't understand your requirement as you have not explained it well enough even your attached sheet does not match your description in the post#1.
But if you want to highlight the cell B2 red when it is less than 50%, you may try this.....
Select B2 --> Conditional Formatting --> New Rule --> Use a formula to determine which cells to format --> in the formula box, paste the formula given below --> Format --> format as per your choice --> OK
Is this what you are trying to achieve?Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Today is the big factor for me.
Like
=(B2<50%,Today()) but this is not working for me
The 50% is relation as of today. That DATA in B2 is updated daily.
Today is the big factor for me.
Like
=(B2<50%,Today()) but this is not working for me
=(B2<50%(Weeknum(today())
The 50% is relation as of today. That DATA in B2 is updated daily.
i need a formular with relation to today (
How is the value in B2 is updated ?
Provide sample workbook showing before and after sheet for better solution.
Punnam
Hi,
Your request is not clear - at least to me. You seem to want to use Today's date in some way in order to make some sort of decision about B4 (or perhaps B2), which implies you want to compare today's date to some other date.
Please clarify with some specific examples which explain what your data says and what results you expect to see.
If the Overall performance is less than 50% of the current week , should reture the figure is B3 red or any color.
You can use "Done", "OFF" NOT" to update the figure is B3
I want to use formular in conditional formatting.
Can someone help Please
Last edited by Emekahalla; 07-10-2014 at 10:10 AM.
Hi,
The today function has no significance .
Find the updated sheet
Punnam
Please don't use the Private Message service for questions about the topic. It is against the forum rules.
If anyone else has received a PM about this one please indicate here.
Sorry about that
but can you assist me?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks