Copy the conditional formatting formula rules with the corresponding cell references

Hello friends,

I'm trying to copy and paste this formatting into hundreds of cells and I have to edit each individual condition for each cell in each individual range.

I have two sheets, intraday, and screener, and I have done there what kind of conditional formatting is needed.
Please check intraday - C3, C4, and screeners B2 and C2.

It would be better if this is done through VBA otherwise a conditional formatting formula that works in less time would be preferable.
Please please please provide me a solution.

Attaching an excel file for reference.

You do not need to change the conditional formatting for each individual cell. If you go into "Home / Conditional Formatting / Manage Rules" and each of the handful of rules you currently have will have an "Applies To" section.
At present you have just one cell in there, but you can specify a range. For example if you put =$C$3:$C$100 in the applies to section the same rule will be applied to all cells from C3 down to C100 in one go.

BSB

Wow, thanks sir,
half of my problem is solved (Intraday sheet)

Now Screener sheet sir

sir any update, please

First of all, sorry for the late response and thank you very much. Sir, I will check and let you know.