Excel Formula Help Conditional Formatting - If A2 TODAY and B2 Y turn A2 Green If B2 N turn A2 RED

0 votes
To highlight a Green or Red outcome, a formula based on two formulas with specific circumstances is all that is needed. Based on the TODAY(), it will either turn A2 Green or Red depending on whether B2 is Y or N.
Dec 28, 2022 in Others by Kithuzzz
• 28,700 points
80 views

1 answer to this question.

0 votes

Create a conditional format rule on A2 which says:

=AND(A2=TODAY(),B2="Y")

This will be true if both A2 equals today and B2 equals "Y." Conditional formatting rules take effect when they contain the word TRUE. Make Green the highlighted colour in this regulation. Put the normal highlighting in red, and if the conditional format is applicable, the red will take precedence.

answered Dec 29, 2022 by narikkadan
• 53,160 points

Related Questions In Others

0 votes
1 answer

Excel - Conditional Formatting not working because cell has an existing formula

Go to Conditional Formatting -> Rules to ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 53,160 points
213 views
0 votes
1 answer

Excel VBA if file closed, then open and paste, else just paste data

Slightly re-worked to add full workbook/sheet qualifiers ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 53,160 points
167 views
0 votes
1 answer

What are the RGB and HEX codes of the 3 color conditional format in Excel?

In Excel 2016 at least the colors ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
• 53,160 points
1,140 views
0 votes
1 answer

Thousand and million formatting for negative numbers (excel/ googlesheets)

Its not possible. What you could do is ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 53,160 points
160 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
213 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
386 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,630 points
175 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 22,940 points
162 views
0 votes
1 answer

How do I calculate Interest rate (R) from EMI formula if I know EMI, Principal (P) and Time (N)?

Try this: #include <iostream> #include <cmath> #include <boost/date_time/posix_time/posix_time.hpp> #include <boost/thread/thread.hpp> #define TOLERANCE ...READ MORE

answered Oct 21, 2022 in Others by narikkadan
• 53,160 points
90 views
0 votes
1 answer

Excel Formula with Nested IF/LEFT/AND Functions

Use this: =IF(SUMPRODUCT(--(LEFT(G3,1)={"1","2","3"}))>0,"998", ...READ MORE

answered Nov 21, 2022 in Others by narikkadan
• 53,160 points
141 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP