Excel Magic Trick 296: Conditional Format Intersection Row & Column

[gstaraz]

Thanks for this great tutorial :up:

[gstaraz]

- In Your example with two intersecting conditional formatted columns/rows, where you have the row formated red and the column formated Yellow; would it be possible to have a cell somewhere in the sheet displayng the value highlighted in orange in Your example?

Example:

In Your tutorial, when You select SR3; PRO2; Mar; You get as a highlighted result the value of "0" (zero)

Now, I would like that value additionally to be displayed in a separate cell in the sheet (let say, in the cell H10

[Karin16121968]

I´m not sure if you received my previous request

[Karin16121968]

Thanks for your helpful tutorial. Please help me to understand how and when how many $ sign I have to put!

To block a row or column /

to block the whole cell if I´m not mistaken is no $ sign isn´t .

Thanks in advance for your help an look forward to reading from you!

I wish you a nice day

[ExcelIsFun]

I have many videos on cell references, here the most comprehensive video:

Search for this title:

Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation

[ForPropertyInvestors]

I can not find one of these anywhere online. Would you be able to show how to make a sheet for Google docs that will highlight dates for either weekly or fortnightly rent payments for a tenant? Something that has the 12 months in the one sheet and a start day of renting till possibly an end date input that can also print. As could print one to give to tenant as well.

[6642633]

WOW

Thanks A Lot

This have been Very Helpfull.......

Thank again and 100000000000000000 Star (if i can)

[ExcelIsFun]

You are welcome!

[Thunderbird2014]

Awesome video.  Thanks.

[ExcelIsFun]

Dear Thunderbird2014,

You are welcome!

Hey what sort of table are you formatting, or what application are you using this trick for?

--excelisfun

[beaniehoke1]

Thanks excelisfun, I watched your video number 296. I have to give you a 10 on this one. It is what I needed for over a year. After watching it 10 times I figured out how to get my lottery program to work.

Thanks a lot, you are great!!!

[ExcelIsFun]

Dear beaniehoke1,

I am glad that you liked this one! I use this all the time for accounting and statistics tables!!

--excelisfun

[tirathmistry]

Awesome tutorial ExcelIsFun

5 star tutorial video tutorial

Nice technique with awesome example

Thanks so much for your time & kind effort for making such a useful & valuable tutorial video form us

Thanks God Bless you

[ExcelIsFun]

Dear tirathmistry,

You are welcome! I am happy to make the videos!

--excelsifun