Excel Conditional Formatting Based on Another Cell Tutorial

Quick Tutorial of Excel Conditional Formatting based on another Cell Value (can be changed by the user)

Recommended Gadgets/Products:

Products:

Check the below Playlists..

Excel Tutorials:

Excel Chart Tutorials:

Excel Pivot Table Tutorials:

Excel Gsuite Tutorials:

Excel Tips & Tricks:

Powerpoint Tutorials:

Gadget Reviews:

Thanks for watching!!! 😊🙏

Please do Subscribe and Hit the Bell 🔔icon to support my efforts and to receive all my videos Notifications.

Follow me on below to stay connected👇

[notakdaplayer]

deleting the $ sign does the trick. been searching internet for hours. thanks ! godbless

[goldenchefsgaminihemalal]

You are just amazing. You Nailed it " Short & Sweet" Blessed to have found you on YT

[farhaa.]

Hallo, thanks for the video, want a small help : for example in atendance sheet if the student is absent for 3 days continiously how to format with color . thanks in advance

[juricivan]

Thanks for your video. I have already subscribed. 👍 Does anybody know how to count coloured cells (coloured using conditional formating) in each row or column?

[benjiwong]

great inf. how do you format condition based on text contains "complete" = green, text contains incomplete = RED? thank you.

[sohit]

How we can applythe conditional formula to change the color of cell based on other correspoding cell value of the same row for the unlimited rows?

[lkrizo]

Hi. Can you make a formula/ when change the color of the cell, date will show on next cell. Thank you

[gajenderyadav]

How you will count them highlighted cell

[georgems]

How to write macro for getting result from another sheet for matching number

[HumanityMatters]

plz help....
I am using this formula in conditional formatting in office 2019 version
=SUM(B$3:INDEX(B$3:B3, ROWS(B$3:B3)-1))<=B$35
but it throws error like "You may not use reference operators (such as union, intersection and ranges) or array constants for conditional formatting criteria"
Note that formula upto INDEX(B$3:B3, ROWS(B$3:B3)-1) is working fine but the moment I am summing as above it throws error....ur help will be greatly appreciated. plz

[lavanyabalakrishnan]

How to group the Pink and Green ones seperately?

[clementinotmalengue]

Thanks for your video. I have problem colouring cells in excel table with for ex. 6 raws & 6 column copared to another table on the same excell sheet with 6 raws & 6 column. Can you help please? Thanks on advance

[janjrukiyasagar]

I want do following this how can I enter formula for this

1) When C1 is equal to D1 then store D1 value in next sheet/ in this sheet
2) again when C1 is equal to D1 then store D1 value in next sheet/ in this sheet below above value

Give me the solution of this

[MrDeepak]

I have 100 columns in which i need to select 30 columns alone and have to do conditional formatting is that possible

[A.E.Carrillo]

You showed only numbers. What conditional formatting based on another cell with Text?

[aarondecker]

This is a basic question, but how did you get cell 5 c-i to be one cell and the lower cells to be broken up into smaller cells?

[carmelmanion]

When I go to manage rules there is no arrow rule in my version of Excel. What Excel version is this tutorial based on?

[netfilmi]

what is the conditional format formula for when LTP(last traded price) changes nearest values to be highlighted in resistance values r3, r2, r1, and support values s1, s2 &s3

[mahaboobhossain]

I NEED THIS FILE SEND TO MY ID BROTHER